PK96276: PANEL ADB21CDI INCORRECT HELP PANEL DESCRIPTION FOR PERCENT COLU MN AND INCORRECT OUTPUT FROM INTERPRET LINE COMMAND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS panel ADB21CDI "Column
  Distribution" help panel ADBH1CDI incorrectly defines the
  "Percent" column. In addition the "Interpret" does not
  correctly report the statistics for the column on panel
  ADB21CD1 "Interpretation of an Object in SYSCOLDIST".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for z/OS    *
  *                 who use the DI command on panel ADB21XC,     *
  *                 then perform PF1 for help on panel           *
  *                 ADB21CDI.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      panel ADB21CDI "Column Distribution"    *
  *                      help panel ADBH1CDI incorrectly defines *
  *                      the "Percent" column. In addition the   *
  *                      "Interpret" does not correctly report   *
  *                      the statistics for the column on panel  *
  *                      ADB21CD1 "Interpretation of an Object   *
  *                      in SYSCOLDIST".                         *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The help text was corrected for the "Percent" column
  description. Panel ADB21CD1 was also modified to show the
  correct "Type of statistics" and values. Type F will show the
  "Percentage of rows in table" and type C will show the
  "Distinct values for column group".
  Type of statistics           : F - Frequent value
  Percentage of rows in table      : 20 (Float:  2.0000000000E-01)
  Type of statistics               : C - Cardinality
  Distinct values for column group : 4384 (Float:  4.38400000E+03)
  

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

•    ADBH1CDI ADB21C   ADB21CD1 ADB21CPS ADB21T
  ADB21TC  ADB21TPS ADB21XC
  

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.