PM80133: PANEL ADB21TAV 'DISPLAY LIMIT KEY VALUES' MISSING INFORMATION WHEN DECIMAL=COMMA / LKEY LINE COMMAND.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' LKEY line command results
  in panel ADB21TAV 'Display Limit Key Values' missing information
  when DECIMAL=COMMA.
  .
  For example, if the limit key was:
  2000,,999,,9999,,999,,'ZZ',999,,'ZZZZZZ',9999-12-28
  it would be displayed as:
  2000, , 999, , 'ZZ', 999, 'ZZZZZZ', '9999-12-28'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who issue the 'LKEY - Display limit     *
  *                 key values' on panel ADB21T Tables, Views,   *
  *                 and Aliases', or panel ADB21X 'Indexes'.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool for z/OS,    *
  *                      when issuing the 'LKEY - Display limit  *
  *                      key values' on panel ADB21T or panel    *
  *                      ADB21X against a partitioning table or  *
  *                      index, the wrong limit key is displayed *
  *                      on panel ADB21TAV 'Alter Partitioned    *
  *                      Table' when DECIMAL=COMMA.              *
  *                                                              *
  *                      For example, if the limit key was:      *
  *                      2000,,999,,9999,,999,,'ZZ',999,,        *
  *                      'ZZZZZZ',9999-12-28                     *
  *                      it would be displayed as:               *
  *                      2000, , 999, , 'ZZ', 999, 'ZZZZZZ',     *
  *                      '9999-12-28'                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In DB2 Administration Tool for z/OS, when the DECIMAL=COMMA,
  the limit key could not be determined correctly if there is
  one or more decimal columns involved in the partition key
  definition.
  

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:

  UK93788 UK93789

Modules/Macros

•    ADBPUTLC ADB21SA  ADB21SAR ADB21SAV ADB21T
  ADB21TA  ADB21TAV ADB21X   ADB21XAR ADB21XAV ADB21XP  ADB26CS
  ADB27C   ADB27CPV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK93788

     UP13/04/27 P F304

• RA20 PSY UK93789

     UP13/04/27 P F304

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.