PK44862: INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X106A001)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x106a001)
  occurs when unloading a VIEW and SELECT contains IF NULL.
  ADDITIONAL SYMPTOM:
  1) After installing HPU 3.1 when running JCL member INZEXECU in
     SINZSAMP library to verify the installation, the following
     error was received:
     LSCX064 ABEND diagnostic messages directed to ddname SYS00001
     IEA995I SYMPTOM DUMP OUTPUT  248
     USER COMPLETION CODE=1206
     PB 8837
  2) Applying to R310 only:
     Unpredictable result (among them, various memory
     ABENDs including U1205) may occur when
     the DB2 SYSTEM AUTHID list has more
     than 245 items.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following applies to V220           *
  *                      1. Wrong message number is displayed.   *
  *                      INZU236 is issued instead of INZU236E.  *
  *                      PB 8697                                 *
  *                      2.Unloaded record contains incorrect    *
  *                      data when type translation from any     *
  *                      data type to CHAR type is involved and  *
  *                      either IF NULL VALUE (UNLOAD PLUS       *
  *                      syntax) or DEFAULTIF (FASTUNLOAD) used  *
  *                      with contant which length is less than  *
  *                      the length of the output field.         *
  *                      PB 8697                                 *
  *                      The following applies to V220 and V310  *
  *                      3. Unload involving SELECT with         *
  *                      expression on a column from a view may  *
  *                      end with Return Code 8 without any      *
  *                      message. This happens only if the       *
  *                      UNLOAD PLUS syntax is used.             *
  *                      PB 8835                                 *
  *                      The following applies to V310           *
  *                      4. Unpredictable result (among them,    *
  *                      various memory ABENDs) may occur when   *
  *                      the DB2 SYSTEM AUTHID list has more     *
  *                      than 245 items.                         *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  1. inzctrlf and inzctrlp modules wre changed to issue the
  message with the expected number.
  2. inzctrlf and inzctrlp were changed.
  3. inzctrlf and inzctrlp were changed.
  4. Call to osysmvsGetAuthid that caused the issue was removed
  from inzquery since this call was useless.
  

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:

  UK26029 UK26030

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R220 PSY UK26029

     UP07/06/19 P F706

• R310 PSY UK26030

     UP07/06/19 P F706

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.