PH42961: OBJECT COMPARE DDL-TO-DDL ADD VERSIONING STATEMENT RESULTS IN ONCODE 520 COMPARE_TABLES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When doing a DDL to DDL compare where columns are appended and a
  table is recreated with ADD VERSIONING, compare results in an
  ONCODE 520 in COMPARE_TABLES.
  
  
  Keyword:  ONCODE520.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who compare tables without including         *
  *                 table spaces and add versioning              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Comparing tables by using a DDL to DDL  *
  *                      comparison results in an ONCODE 520     *
  *                      when versioning is added to the table.  *
  ****************************************************************
  When tables are compared without including table spaces,
  the compare fails with an ONCODE 520. The comparison
  stops at the ONCODE when versioning is added after the tables
  are compared.
  

Problem conclusion

• The 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:

  UI79889

Modules/Macros

• ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79889

     UP22/03/26 P F203

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.