PI26652: DDL/GEN COMMAND PRODUCES INVALID INDEX ENDING AT CLAUSE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' DDL and GEN commands
  produce DDL with an invalid INDEX ENDING AT clause when the
  DB2 Catalog column SYSIBM.SYSTABLEPART.LIMITKEY contains a
  string constant which is does not follow the DB2 syntax rules
  for string constant's i.e. is not delimited by quotes at the
  beginning and end of the string.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Generate (GEN) function     *
  *                 on an index.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The GEN commands produces DDL with an   *
  *                      invalid INDEX ENDING AT clause when     *
  *                      the DB2 catalog column                  *
  *                      SYSIBM.SYSTABLEPART.LIMITKEY            *
  *                      contains a string constant which is     *
  *                      not delimited by quotes at the          *
  *                      beginning and end of the string.        *
  *                                                              *
  *                      For example:                            *
  *                      CREATE INDEX >index_name<               *
  *                        ON >table_name<                       *
  *                         (COL1             ASC)               *
  *                         (PARTITION 1 ENDING AT ('),          *
  *                          PARTITION 2 ENDING AT (')           *
  *                          )                                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Performing GEN on an index generates an invalid ENDING AT
  clause.
  

Problem conclusion

• Problem has been resolved.  The correct DDL is now generated:
  
  CREATE INDEX >index_name<
    ON >table_name<
     (COL1             ASC)
     (PARTITION 1 ENDING AT ('xxxxx'),
      PARTITION 2 ENDING AT ('yyyyy')
      )
  
  where xxxxx and yyyyy are limit keys.
  

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

•    ADB2REM  ADB21TAV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI23839

     UP14/12/16 P F412

• RB10 PSY UI23840

     UP14/12/16 P F412

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.