PH34989: SUPPORT DB2 DECIMAL=COMMA FOR IZDS AND IZPCA COMPONENTS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Support Db2 decimal=comma for IZDS and IZPCA components
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: IBM Z Performance and Capacity Analytics     *
  *                 customers                                    *
  *                 a) Running with Db2 option decimal=comma.    *
  *                 or                                           *
  *                 b) Installing Capacity Planning for z/OS.    *
  ****************************************************************
  * PROBLEM DESCRIPTION: a) Message DSNT408I SQLCODE = -104,     *
  *                      ERROR: ILLEGAL SYMBOL with RC=08 when   *
  *                      installing the zERT component with the  *
  *                      Db2 specification of decimal=comma.     *
  *                      The same error running the sample job   *
  *                      DRLJCP09.                               *
  *                      b) RC=04 when installing the Capacity   *
  *                      Planning for z/OS component with        *
  *                      message DRL3003W The length of the      *
  *                      table name exceeds 254 characters.      *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF(s).                   *
  ****************************************************************
  a) SQL sample did not have a space before a numeric value
  following a comma, which is a requirement of systems running
  with Db2 decimal=comma
  b) The install process was calculating the length of a Db2
  table name incorrectly.
  

Problem conclusion

• a) The object has been changed to add a space
  between the comma and the following numeric value to meet
  the requirements when Db2 is started with decimal=comma.
  b) The install process has been updated to correctly
  calculate the Db2 table name.
  

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:

  UI74549 UI74550

Modules/Macros

• DRLERDEF DRLJCP09 DRLTZERT
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• RC01 PSY UI74549

     UP21/03/25 P F103

• RCA8 PSY UI74550

     UP21/03/25 P F103

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.