PK53214: DDL GENERATED IS INVALID FOR LIMITKEY WHEN DSNHDECP DECIMAL=COMMA IS USED. E.G. (99,, 9999,,)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool, when using the LKEY command and
  having a DSNHDECP DECIMAL=COMMA and the Partition values use the
  null string ',,' the generated DDL is invalid.
  .
  Additional symptoms: decimal comma
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2  Admin Tool who use the LKEY    *
  *                 line command to view limitkey values on a    *
  *                 decimal-as-comma system.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: In DB2 Administration Tool, when using  *
  *                      the LKEY command and having a DSNHDECP  *
  *                      DECIMAL=COMMA,  the displayed limitkey  *
  *                      values may not be correct.              *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Decimal data was not being properly recognized, causing
  follow-on fields to not be quoted.
  

Problem conclusion

• The problems have 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

•    ADB21TAV
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R710 PSY UK33038

     UP08/01/25 P F801

• R720 PSY UK33039

     UP08/01/25 P F801

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.