PM81441: PANEL ADB21T CDI LINE COMMAND RESULTS IN ERROR RUNNING ADB21CDI,LINE 146: BAD ARITHMETIC CONVERSION

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' CDI 'Show column
  distribution statistics' line command issued on panel ADB21T
  'Tables, Views, and Aliases' when running on a  DB2 10 CM8
  subsystem results in a message:
     146 +++         TEMP = C2X(BITXOR(TEMP,HEXX)) / (10 ** SCALE
  )
      52 +++  CALL CONVERT_ROW
  Error running ADB21CDI, line 146: Bad arithmetic conversion
  ***
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who issues the 'CDI - Show column       *
  *                 distribution' line command on panel          *
  *                 ADB21T 'Tables, Views, and Aliases'.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When issuing the 'CDI - Show column     *
  *                      distribution' line command on panel     *
  *                      ADB21T, an error is displayed:          *
  *                                                              *
  *                      146 +++         TEMP =                  *
  *                      C2X(BITXOR(TEMP,HEXX)) /                *
  *                      (10 ** SCALE )                          *
  *                      52 +++  CALL CONVERT_ROW                *
  *                      Error running ADB21CDI,                 *
  *                      line 146: Bad arithmetic conversion     *
  *                      ***                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the 'CDI - Show column distribution' line command
  on panel ADB21T to show the column distribution, if a null
  value is allowed for a column, and this value is seen
  frequently in the catalog table, a bad arithmetic conversion
  error is encountered. The null value entry in the catalog
  table is an illegal value for the built-in function BITXOR.
  

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:

  UK93459 UK93460

Modules/Macros

•    ADB21CDI
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK93459

     UP13/04/18 P F304

• RA20 PSY UK93460

     UP13/04/18 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.