PI93189: WRONG DDLDDN FILE ANALYSIS IF APPEND / LOGGED / COMPRESS / DSSIZE / BUFFERPOOL / MEMBER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload specifying the DDLDDN option can fail with various
  errors among which:
  - the following DDL analysis errors reported by the messages
     below:
     INZC004E INCOMPLETE OBJECT DEFINITION FOR TABLESPACE
              dbname,tablespace PARTITIONNING INDEX MISSING
     INZI516E DDL ANALYSING: INVALID DDL DEFINITION.
  - incorrect encoding of the output data
  
  These errors can occur if the file provided contains one of the
  following keywords sequences in the CREATE TABLE statement:
  - APPEND YES
  - APPEND NO
  - LOGGED
  - NOT LOGGED
  - COMPRESS YES
  - COMPRESS NO
  - DSSIZE integer G
  - BUFFERPOOL bpname
  - MEMBER CLUSTER
  - TRACKMOD YES
  - TRACKMOD NO
  - PAGENUM RELATIVE
  - PAGENUM ABSOLUTE
  
  INZC004E INZC004 MSGINZC004E MSGINZC004
  INZI516E INZI516 MSGINZI516E MSGINZI516
  PB51334 Z632
  

Local fix

• Remove any of the keyword sequences listed above from from the
  CREATE TABLE statements in the DDLDDN file as this does not have
  any impact on the DB2 HPU output.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: An unload specifying the DDLDDN option  *
  *                      can fail with various errors among      *
  *                      which:                                  *
  *                      - the following DDL analysis errors     *
  *                       reported by the messages below:        *
  *                         INZC004E INCOMPLETE OBJECT           *
  *                          DEFINITION FOR TABLESPACE           *
  *                          dbname,tablespace PARTITIONNING     *
  *                          INDEX MISSING                       *
  *                         INZI516E DDL ANALYSING: INVALID DDL  *
  *                          DEFINITION.                         *
  *                      - incorrect encoding of the output      *
  *                       data                                   *
  *                      These errors can occur if the file      *
  *                      provided contains one of the following  *
  *                      keywords sequences in the CREATE        *
  *                      TABLE statement:                        *
  *                                                              *
  *                      - APPEND YES                            *
  *                      - APPEND NO                             *
  *                      - LOGGED                                *
  *                      - NOT LOGGED                            *
  *                      - COMPRESS YES                          *
  *                      - COMPRESS NO                           *
  *                      - DSSIZE integer G                      *
  *                      - BUFFERPOOL bpname                     *
  *                      - MEMBER CLUSTER                        *
  *                      - TRACKMOD YES                          *
  *                      - TRACKMOD NO                           *
  *                      - PAGENUM RELATIVE                      *
  *                      - PAGENUM ABSOLUTE                      *
  *                      pb51334                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzmsgs and inzctrlh modules were changed.The oddlx2y
  module was 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

•    INZUTILX
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI53962

     UP18/02/23 P F802

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.