PK05978: ALTER INDEX PANEL ADB21XA WILL NOT DISPLAY SQTY VALUE LARGER THAN 131068 - IGNORING SECQTYI

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool an ALTER INDEX operation in panel
  adb21xa will not display a value larger than 131068 for SQTY
  ( secqty secondary quantity ). Appears to be using SQTY and
  ignoring SECQTYI value from DB2 catalog.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool R510, who   *
  *                 want to change  the  SQTY of a partitioned   *
  *                 index, may be affected.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When executing DB2 Administration  R510 *
  *                      in DB2 R710, the  calculation  of  SQTY *
  *                      displayed in ADB21XA is incorrect after *
  *                      an ALTER.                               *
  *                      .*                                      *
  *                      In DB2  Administration  Tool  an  ALTER *
  *                      INDEX operation  in  panel ADB21XA will *
  *                      not display a value  larger than 131068 *
  *                      for SQTY ( secqty secondary quantity ). *
  *                      It appears  to  be using SQTY, ignoring *
  *                      SECQTYI value from DB2 catalog.         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The SQTY for a partition index is not displayed properly in
  ADB21XA after an ALTER with a value larger then 131068.
  

Problem conclusion

• Code has been fixed to display the SQTY after an ALTER with a
  size greater then 131068.
  

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

•    ADB21XP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK05805

     UP05/08/04 P F508

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.