PH05894: INCORRECT PROCESSING OF PGSIZE FROM SYSIBM.SYSINDEXES FOR INDEXES THAT WERE CREATED PRIOR TO VERSION 9

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Before this fix, if the index was created prior to Db2 Version 9
  (when PGSIZE is 4096 in SYSIBM.SYSINDEXS for a 4 KB page size)
  and its matching index was created on a later Db2 version
  (when PGSIZE is 4), then an IX_PGSIZE mismatch is printed, and
  the index is excluded from table space cloning for REBUILD.
  After applying this fix, this situation is not treated as a
  mismatch.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Before this fix, if the index was       *
  *                      created prior to Db2 Version 9          *
  *                      (when PGSIZE is 4096 in                 *
  *                      SYSIBM.SYSINDEXS for a 4 KB page size)  *
  *                      and its matching index was created on   *
  *                      a later Db2 version (when PGSIZE is 4), *
  *                      then an IX_PGSIZE mismatch is printed,  *
  *                      and the index is excluded from table    *
  *                      space cloning for REBUILD. After        *
  *                      applying this fix, this situation is    *
  *                      not treated as a mismatch.              *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UI60244

Modules/Macros

•    CKZ00543 HCKZ320
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI60244

     UP18/12/13 P F812

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.