PK07389: ADMIN TOOL PANEL ADB21CDI DISTRIBUTION STATISTICS PANEL SHOWS INVALID DATE VALUES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• For a Date value of 19970707 Admin shows 9707-07-40 on the
  ADB21CDI panel. Values are correct in the catalog.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool,  who       *
  *                 display column distribution statistics       *
  *                 and values, are affected.                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Values of certain data types are        *
  *                      displayed incorrectly.                  *
  *                      .*                                      *
  *                      ADB21CDI (DISTRIBUTION STATISTICS)      *
  *                      panel shows INVALID DATE VALUES         *
  *                      .*                                      *
  *                      For a Date value of 19970707, it shows  *
  *                      9707-07-40 on the ADB21CDI panel        *
  *                      (values are correct in the catalog).    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description.
  

Problem conclusion

• Apply the fixes for the following problems:
  .* VARCHAR and TIMESTAMP data are not handled.
  .* Values for DATE and TIME columns that do not allow nulls are
     displayed incorrectly.
  .* Values of CHAR columns that allow nulls is offset by one byte
  .* Negative numbers are displayed incorrectly.
  .* Postive numbers in nullable columns are displayed incorrectly
  

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:

  UK06373 UK06374

Modules/Macros

•    ADB21C   ADB21CDI ADB21CPS ADB21T   ADB21TC
  ADB21TPS ADB21XC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R510 PSY UK06373

     UP05/08/26 P F508

• R710 PSY UK06374

     UP05/08/26 P F508

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.