PM18116: ADB2MEX PANEL SHOWS INVALID KEYLENGTH WHEN USING AL ON INDEX THEN ? ON PRIQTY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using DB2 Administration Tool for z/OS to ALTER an
  INDEX and ? is used on PRIQTY, KEYLENGTH shown is
  invalid.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the AL command on           *
  *                 an index, then "?" on the PRIQTY field.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the DB2 Administration       *
  *                      Tool for z/OS to ALTER an INDEX         *
  *                      and "?" is used on the PRIQTY field,    *
  *                      the KEYLENGTH value shown is invalid.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The value of the KEYLENGTH field is missed.
  

Problem conclusion

• Program has been modified to display the KEYLENGTH
  value. The help panel ADBHMEX has been modified to
  explain where the values of fields "No. of keys" and
  "Key length" come from when the RUNSTATS utility has
  not been run.
  

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

•    ADBHMEX  ADB2MEX  ADB2MEXG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK64491

     UP11/02/06 P F102

• R720 PSY UK64492

     UP11/02/06 P F102

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.