PH53740: ADMIN TOOL: CREATE UNIQUE INDEX STATEMENT INCORRECTLY ADDING DSSIZE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Admin Tool:  CREATE UNIQUE INDEX statement incorrectly
  adding DSSIZE
  
  
  DESCRIPTON:  When Compare causes the create of a tablespace with
  PAGENUM RELATIVE along with a unique index, the CREATE UNIQUE
  INDEX statement adds a DSSIZE statement to the CREATE DDL. This
  value is picked up from the tablespace but it's incorrect since
  the index should not have a DSSIZE statement. Source DDL does
  not have DSSIZE specified for INDEX.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the Db2 Administration Tool for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When an index is created for a table    *
  *                      with relative page numbering, the       *
  *                      generated DDL for the index fails       *
  *                      with SQLCODE -628 as the DSSIZE is      *
  *                      included in the DDL.                    *
  *                                                              *
  ****************************************************************
  When an index is created on a table with PAGENUM RELATIVE,
  the GEN function assigns the index partition DSSIZE to the
  CREATE INDEX DDL. This syntax is incorrect and fails with
  SQLCODE -628. The error occurs, because DSSIZE is included in
  the DDL. The correct syntax should not include DSSIZE.
  

Problem conclusion

• The problem has been resolved.
  Search Keywords: SQLCODE -628
  

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:

  UI92666 UI92674

Modules/Macros

• ADB2REG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI92666

     UP23/07/13 P F307

• RD10 PSY UI92674

     UP23/07/13 P F307

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.