PI78182: WRONG 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

• PGSIZE in SYSIBM.SYSINDEXES contains the value 4, 8, 16, or 32
  which indicates the size, in KB, of the leaf pages in the index.
  If the index was created prior to Version 9, the value will be
  4096 for a 4 KB page size.
  Cloning Tool should recognize indexes that were created prior
  to Version 9 and use right value of PGSIZE.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: PGSIZE in SYSIBM.SYSINDEXES contains    *
  *                      the value 4, 8, 16, or 32 which         *
  *                      indicates the size, in KB, of the leaf  *
  *                      pages in the index. If the index was    *
  *                      created prior to Version 9, the value   *
  *                      will be 4096 for a 4 KB page size.      *
  *                      Cloning Tool should recognize indexes   *
  *                      that were created prior to Version 9    *
  *                      and use right value of PGSIZE.          *
  ****************************************************************
  * 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:

  UI46212

Modules/Macros

•    CKZ00544 CKZ00554
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI46212

     UP17/04/07 P F704

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.