PK96741: LKEY DISPLAY FOR TABLE DIFFERS FROM LKEY DISPLAY FOR INDEX FOLLOWING USE OF ALTER TABLE ROTATE PARTITION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool the use of ALTER TABLE ROTATE
  PARTITION can cause the LKEY command display in panel ADB21TAV
  to display different values, depending on whether the LKEY
  command is issued against the table, or the underlying
  partitioning INDEX.
  .
  LKEY against the table results in correct key display in
  correct order, where keys appear in ascending or descending
  order, depending on the INDEX definition.
  .
  Using an ascending partitioning INDEX, and using LKEY command
  against the partitioning INDEX shows 'rotated' partitions key
  values first, followed by 'remaining' partitions' key values.
  This panel ADB21TAV display is not in true ascending order, as
  the 'rotated' partitions have higher key values than  the
  'remaining', original partitions' key values. As a result of the
  incorrect order of key values, keys appear to be associated with
  incorrect partition numbers in the panel ADB21TAV display.
  

Local fix

• Use table LKEY display
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the LKEY command on panels ADB21X    *
  *                 "Indexes" and ADB21T "Tables, Views, and     *
  *                 Aliases" and the results were not the same.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the LKEY command on panels   *
  *                      ADB21X and ADB21T the partition orders  *
  *                      are different.                          *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The SELECT commands ORDER BY is different in panels ADB21X and
  ADB21T.
  

Problem conclusion

• The problem has been fixed.
  

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

•    ADB21X
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK52000

     UP09/11/21 P F911

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.