PM38754: ERRONEOUSLY ISSUED INZI516E DDL ANALYSING: INVALID DDL DEFINITION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload from an image copy (COPYDDN option) fails if the
  DDLDDN option is used and the DDL for this option includes the
  PARTITION BY SIZE option of the CREATE TABLE statement.
  The unload ends with completion code 8 and issues msg
  
     INZI516E DDL ANALYSING: INVALID DDL DEFINITION.
  
  PB11170
  

Local fix

• Replace the PARTITION BY SIZE option by PART BY SIZE or
  move the PARTITION BY SIZE option to the end of the
  CREATE TABLE statement.
  Also consider removing the PARTITION BY SIZE option as it is not
  mandatory since the CREATE TABLESPACE must already specify the
  MAXPARTITIONS option that indicates the table space is a
  partition-by-growth table space.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The unload from an image copy (COPYDDN  *
  *                      option) fails if the DDLDDN option is   *
  *                      used and the DDL for this option        *
  *                      includes the PARTITION BY SIZE option   *
  *                      of the CREATE TABLE statement. The      *
  *                      unload ends with completion code 8 and  *
  *                      issue msgINZI516E DDL ANALYSING:        *
  *                      INVALID DDL DEFINITION. Local fix:      *
  *                      Replace the PARTITION BY SIZE option    *
  *                      by PART BY SIZE or move the PARTITION   *
  *                      BY SIZE option to the end of the        *
  *                      CREATE TABLE statement. Also consider   *
  *                      removing the PARTITION BY SIZE option   *
  *                      as it is not mandatory since the        *
  *                      CREATE TABLESPACE must already specify  *
  *                      the MAXPARTITIONS option that           *
  *                      indicates the table space is a          *
  *                      partition-by-growth table space.        *
  *                      PB 11170                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The oddlx2 module was changed to support the PARTITION BY SIZE
  sequence.
  

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

•    INZADBSK INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK73227

     UP11/11/02 P F111

• R410 PSY UK73228

     UP11/11/02 P F111

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.