PM20325: DB2 OBJECT COMPARISON TOOL FOR Z/OS COMPARES TWO TABLES AND THE NEWLY INSERTED COLUMN IS OMITTED DURING LOAD.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare two tables and rename a column and insert a new column.
  The apply job failed with rc=8 on step LOAD0001 and the newly
  inserted column is omitted during load.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS and DB2 Object Comparison               *
  *                 Tool for z/OS who attempt to compare         *
  *                 and apply changes to a table with an         *
  *                 IDENTITY column.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The LOAD in the apply job fails         *
  *                      with message DSNU323I                   *
  *                      "COLUMN 'column_name'                   *
  *                      IS OMITTED".                            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  When performing the ALC operation, the backend
  logic adds IDENTITYOVERRIDE to the LOAD
  control cards, which in turn requires the presence of
  the IDENTITY column in the LOAD field specification list.
  However, if the column is new, it will not appear in the
  field specification list.
  

Problem conclusion

• The program was modified to add IDENTITYOVERRIDE
  to the LOAD control cards only when the IDENTITY column
  is not new.
  

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:

  UK60012

Modules/Macros

•    ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK60012

     UP10/08/31 P F008

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.