PM26761: LOGICAL UNLOAD GENERATES MESSAGES INZU025E AND INZU063I

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload with an SQL statement involving an expression
  such as cast_to_numeric_function(...SUBSTR(numerical_string)...)
  where cast_to_numeric_function is one of the following scalar
  functions: BIGINT, INTEGER, SMALLINT, FLOAT, DECIMAL, DECFLOAT
  and numerical_string stands for a string which is a
  representation of a numerical value is not correctly processed.
  If native mode is requested (DB2 NO), the unload fails and ends
  with completion code 8 and msgINZU025E.
  If non-native mode is allowed (DB2 YES), the unload is
  successfull but is unduly processed via DB2 and ends with
  completion code 4 and msgINZU063I.
  PB 10943
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload with an SQL statement  *
  *                      involving an expression such as         *
  *                      cast_to_numeric_function(...SUBSTR      *
  *                      (...)...) where                         *
  *                      cast_to_numeric_function is one of the  *
  *                      following scalar functions: BIGINT,     *
  *                      INTEGER, SMALLINT, FLOAT, DECIMAL,      *
  *                      DECFLOAT is not correctly processed.    *
  *                      If native mode is requested (DB2 NO),   *
  *                      the unload fails and ends with          *
  *                      completion code 8 and msgINZU025E.      *
  *                      If non-native mode is allowed           *
  *                      (DB2 YES), the unload is successfull    *
  *                      but is unduly processed via DB2 and     *
  *                      ends with completion code 4 and         *
  *                      msgINZU063I.                            *
  *                      PB 10943                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inznode was changed to correctly process the SUBSTR() function.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK63535

     UP11/01/05 P F101

• R320 PSY UK63536

     UP11/01/05 P F101

• R410 PSY UK63537

     UP11/01/05 P F101

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.