PI15209: THE DB2 ADMINISTRATION TOOL FOR Z/OS' WSL APPLY JOB FROM COMPARE PROCESS DISCARDS ROWS DURING THE DB2 LOAD UTILITY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' WSL APPLY job from
  COMPARE process discards rows during the DB2 LOAD utility
  when detecting multiple changes in TABLE definition
  The DB2 LOAD will show:
  DSNU310I  ssid  DSNURCON - RECORD (n) WILL BE DISCARDED
  DUE TO 'column'  CONVERSION ERROR FOR schema.table  ERROR CODE
  '04  - INPUT PACKED DECIMAL IS IN ERROR'
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and DB2 Object Comparison Tool for      *
  *                 z/OS who make a change to the table by       *
  *                 deleting columns and adding new columns.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The APPLY job from the Compare process  *
  *                      discards rows during the DB2 LOAD       *
  *                      utility processing when there are       *
  *                      multiple columns being deleted from     *
  *                      and added into the table.  The problem  *
  *                      happens because the LOAD control        *
  *                      statement generated by the product      *
  *                      has incorrect POSITION settings for     *
  *                      the new columns in the field            *
  *                      specification.  The DB2 LOAD utility    *
  *                      output will show:                       *
  *                                                              *
  *                      DSNU310I  ssid  DSNURCON -              *
  *                      RECORD (n) WILL BE DISCARDED            *
  *                      DUE TO 'column'  CONVERSION             *
  *                      ERROR FOR schema.table                  *
  *                      ERROR CODE '04  - INPUT                 *
  *                      PACKED DECIMAL IS IN ERROR'             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The APPLY job from the Compare process discards rows during the
  DB2 LOAD utility processing when there are multiple columns
  being deleted from and added into the table.
  

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:

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI19668

     UP14/07/18 P F407

• RB10 PSY UI19669

     UP14/07/23 P F407

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.