PM50670: UNLOAD STOPS ISSUING MESSAGE ABOUT DDLDDN CONTENT WHERE DDLDDN SPECIFIES PARTITION BY SIZE CLAUSE BEFORE THE IN DB.TS CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The unload stops and issues an error message mentioning an error
  in the DDLDDN content. This occurs where the DDL of the table
  specified in the DDLDDN file specifies the PARTITION BY SIZE
  clause before the IN database.tablespace clause.
  
  For example:
  
   CREATE TABLE HUADMIN.HPUT1
    (C1 SMALLINT,
     C2 DECIMAL(9,2),
     C3 CHAR(40))
     PARTITION BY SIZE EVERY 1G
     IN DBHPUT1.TLHPUT1 ;
  
  PB11297
  

Local fix

• Specify the IN database.tablespace before the PARTITION BY SIZE
  clause.
  
  For example:
   CREATE TABLE HUADMIN.HPUT1
    (C1 SMALLINT,
     C2 DECIMAL(9,2),
     C3 CHAR(40))
     IN DBHPUT1.TLHPUT1
     PARTITION BY SIZE EVERY 1G ;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  *                 All users of HPU 3.2 and 4.1.                *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  *                      The unload stops and issues an          *
  *                      error message mentioning an             *
  *                      error in the DDLDDN content.            *
  *                      This occurs where the DDL of            *
  *                      the table specified in the              *
  *                      DDLDDN file specifies the               *
  *                      PARTITION BY SIZE clause                *
  *                      before the IN database.tablespace       *
  *                      clause.                                 *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                       CREATE TABLE HUADMIN.HPUT1             *
  *                                                              *
  *                        (C1 SMALLINT,                         *
  *                                                              *
  *                         C2 DECIMAL(9,2),                     *
  *                                                              *
  *                         C3 CHAR(40))                         *
  *                                                              *
  *                         PARTITION BY SIZE EVERY 1G           *
  *                                                              *
  *                         IN DBHPUT1.TLHPUT1 ;                 *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• The oddlx2  module was changed.
  

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

•    INZRSAVE INZUTILK INZUTISK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK74261

     UP11/12/02 P F112

• R410 PSY UK74262

     UP11/12/02 P F112

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.