PI86541: OBJECT COMPARE CONVERT OF NON-PARTITIONED TO PARTITIONED INDEX GENERATES PIECESIZE PARM AND CREATE FAILS WITH SQLCODE = -876

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When converting an index from non-partitioned to partitioned,
  Object Compare erroneously generates a PIECESIZE parameter for
  the partitioned index.   Attempting to create the index results
  in:
  
  DSNT408I SQLCODE = -876, ERROR:  'INDEX' CANNOT BE CREATED OR
  ALTERED, REASON 'PIECESIZE IS NOT VALID'
  

Local fix

• Remove 'PIECESIZE' from the JCL for the run step of the Object
  Compare job.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a change is run to convert a       *
  *                      table space from partition-by-growth    *
  *                      to partition-by-range, the result may   *
  *                      be:                                     *
  *                                                              *
  *                      SQLCODEN876 / SQLCODE=-876              *
  *                      DSNT408I SQLCODE = -876, ERROR:         *
  *                      'INDEX' CANNOT BE CREATED OR            *
  *                      ALTERED, REASON                         *
  *                      'PIECESIZE IS NOT VALID'                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When convering a table space from partition-by-growth to
  partition-by-range, the index is changed from type 2 to
  type P.   However, Admin Tool erroneously generates
  the PIECESIZE option for the partitioned index. When the
  change is run, the results is error  SQLCODEN876 /
  SQLCODE=-876:
  
  DSNT408I SQLCODE = -876, ERROR:
  'INDEX' CANNOT BE CREATED OR ALTERED,
  REASON 'PIECESIZE IS NOT VALID'
  

Problem conclusion

• Problem has been resolved.
  

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

•    ADBCCMM  ADB2CME
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI52201

     UP17/11/30 P F711

• RC10 PSY UI52202

     UP17/11/30 P F711

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.