PI64920: GEN DDL GENERATES NUMPARTS KEYWORD EVEN WHEN PBG NUMPARTS VALUE IS SET TO 'DEFINED'

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• According to the DB2 Administration Tool Users Guide, if PBG
  NUMPARTS value is set to 'DEFINED', then 'The NUMPARTS clause
  will be generated with the value that was used when the table
  space was created.'  However, if a tablespace was created with
  MAXPARTITIONS, but not NUMPARTS, and more than one partitions
  is later created at the same time, then a NUMPARTS clause equal
  to this number of partitions will be generated in the DDL.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who refer to help panel ADBHGEN     *
  *                 'HELP: DB2 Admin Generate SQL from DB2       *
  *                 catalog'.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The description of the 'Defined'        *
  *                      option for 'PBG NUMPARTS value'         *
  *                      on help panel ADBHGEN was not           *
  *                      complete.                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The description of the 'Defined' option for 'PBG NUMPARTS
  value' on help panel ADBHGEN 'HELP: DB2 Admin Generate SQL
  from DB2 catalog' was not complete:
  
  Defined  - The NUMPARTS clause will be generated with the
             value used when the table space was created.
  

Problem conclusion

• The description of the 'Defined' option for 'PBG NUMPARTS
  value' on help panel ADBHGEN has been changed to:
  
  Defined  - The NUMPARTS clause will be generated
             with the value used when the table
             space was created.  If NUMPARTS was
             not specified in the DDL at create
             time, the value that gets generated
             in the DDL will be the number of
             partitions that DB2 initially creates
             - all having the same created
             timestamp in the DB2 catalog (column
             CREATEDTS in table SYSTABLEPART).
  

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:

  UI40231 UI40232

Modules/Macros

•    ADBHGEN
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI40231

     UP16/09/01 P F608

• RB20 PSY UI40232

     UP16/09/01 P F608

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.