PI85937: INZU366I UTILITY RETURN CODE 8 (REASON CODE 0X32A00B) WHEN DDLDDN CONTAINS INCORRECT SYNTAX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload job requesting the data from an image copy to be
  unloaded using the DDLDDN fails with a completion code of 8
  after having issued the following message:
  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x32a00b). but no
  message explaining the reason of the error.
  
  This occurs if one of the following condition is fullfilled
  1) the DDLDDN data set contains certain king of syntax error
  such as a truncated CREATE TABLE without any IN database or IN
  database.tablespace clause.
  2) the CREATE TABLESPACE in the DDLDDN data set contains at the
  same time SEGSIZE 0 and NUMPARTS
  
  the tablespace is considered as a segmented tablespace instead
  of a partitioned tablespace.
  
  PB50125
  

Local fix

• Correct DDLDDN accordingly.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload job requesting the data from  *
  *                      an image copy to be unloaded using the  *
  *                      DDLDDN fails with a completion code of  *
  *                      8 after having issued the following     *
  *                      message:                                *
  *                                                              *
  *                      INZU366I UTILITY RETURN CODE 8          *
  *                       (REASON CODE 0x32a00b). but no         *
  *                       message explaining the reason of the   *
  *                       error.                                 *
  *                                                              *
  *                      This occurs if one of the following     *
  *                      condition is fullfilled                 *
  *                      1. the DDLDDN data set contains         *
  *                       certain king of syntax error such as   *
  *                       a truncated CREATE TABLE without any   *
  *                       IN database or IN database.tablespace  *
  *                       clause.                                *
  *                      2. the CREATE TABLESPACE in the DDLDDN  *
  *                       data set contains at the same time     *
  *                       SEGSIZE 0 and NUMPARTS                 *
  *                                                              *
  *                      the tablespace is considered as a       *
  *                      segmented tablespace instead of a       *
  *                      partitioned tablespace.                 *
  *                      PB 50125                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The oddlx2y,  oddlx2 and omsgsmsg  modules were changed.
  

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

• R430 PSY UI52310

     UP17/12/11 P F712

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.