PM58897: RECOVERY CHANGE FOR COMMA IS DECIMAL SUBSYSTEM LOAD UTILITY DISCARDS ROWS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' 'Generate a recover
  change' YES on panel ADB2C11A 'Generate Analyze Job' created
  invalid load control statements for a DECIMAL IS COMMA subsystem
  which causes the LOAD to discard the rows during RELOAD.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who change a column from Decimal        *
  *                 to Char or recover back from Char to         *
  *                 Decimal when using the Alter Table (ALT)     *
  *                 or Change Management function.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      'Generate a recover change'= YES on     *
  *                      panel ADB2C11A 'Generate Analyze Job'   *
  *                      created an invalid LOAD control         *
  *                      statement for a DECIMAL IS COMMA        *
  *                      subsystem which causes the LOAD         *
  *                      to discard the rows during RELOAD.      *
  *                                                              *
  *                      The following error message is          *
  *                      generated upon RELOAD:                  *
  *                                                              *
  *                      DSNU310I DSNURCON - RECORD (n)          *
  *                               WILL BE DISCARDED DUE          *
  *                               TO 'column' CONVERSION         *
  *                               ERROR FOR >schema<.>table<     *
  *                               ERROR CODE '02 - INPUT         *
  *                               NUMERIC INVALID'.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Administration Tool for z/OS erroneously generates
  PERIOD for a decimal place instead of COMMA during an UNLOAD of
  data when converting from DECIMAL to CHAR if the system setting
  of decimal point is COMMA.
  

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:

  010PC2Ÿ UK78053 010PC2Ÿ

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK78053

     UP12/04/20 P F204

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.