PI71909: DB2 OBJECT COMPARE CM BATCH COMPARE GETS ERROR ADB8014E IN THE ANALYZE DURING MERGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Running a CM BATCH COMPARE gets error message in the ANALYZE
  during MERGE:
  
  MERGE REPORT
  ============
  ADB8014E An attempt was made to alter the table attributes of a
           table that d not contain the TB record to be changed.
  ADB8057I Object details at the time of error:
                Operation       : 50
                Row type        : TB
                Object qualifier: DB2ADM
                Object name     : TSPACE_EXCEPTION
                Procedure       : merge_tables
  
  The DDL contains a CREATE TABLE/RENAME sequence and it appears
  that the compare process generates change statements which
  refer to the "new" table name before the RENAME actually takes
  place. This leads to the problem situation.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool          *
  *                 for z/OS who use Change Management           *
  *                 with compare source containing the           *
  *                 RENAME TABLE statement.                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When comparing a source containing      *
  *                      the RENAME TABLE statement and          *
  *                      some other change(s) to the             *
  *                      same TABLE being renamed, the           *
  *                      change is registered and analyzed,      *
  *                      Change Management encounters            *
  *                      error ADB8014E / msgadb8014e.           *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When a source contains a RENAME TABLE statement and some
  other change(s) to the same TABLE being renamed, Change
  Management encounters error ADB8014E / msgadb8014e and
  information message ADB8057I / msgadb8057i:
  
  ADB8014E An attempt was made to alter the table attributes
  of a table that does not contain the TB record to be changed.
  
  ADB8057I Object details at the time of error:
                Operation       : 50
                Row type        : TB
                Object qualifier: >table_schema<
                Object name     : >table_name<
                Procedure       : merge_tables
  

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

•    ADB2CMT  ADB2CMU
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI45180

     UP17/03/07 P F703

• RB20 PSY UI45181

     UP17/03/07 P F703

• RC10 PSY UI45191

     UP17/03/07 P F703

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.