PH02306: CM BATCH OR OBJECT COMPARE ANALYZE WSL MAY NOT INCLUDE COLUMN RENAME WHEN TABLE IS ALSO RENAMED RENAMETB RENAMECOL MASK

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When running a CM Batch or Object Compare Analyze where
  RENAMETB and RENAMECOL mask specifications are used, and both a
  table and a column are renamed,  the Analyze output mentions
  the table rename but may not include the column rename. As a
  result, the run WSL also may not include the column rename DDL.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 who use Change Management, and users of      *
  *                 Db2 Object Comparison Tool for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: When tables are compared with           *
  *                      RENAMETB and RENAMECOL masks            *
  *                      specifications, and both a              *
  *                      table and column are renamed,           *
  *                      the rename column changes               *
  *                      are missing in the run WSL.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When tables are compared with RENAMETB and RENAMECOL masks
  specifications, and both the table and a column are renamed,
  ANALYZE may identify only the table rename.  As a result, the
  rename column change may be missing from the run WSL.
  

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
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI60203

     UP18/12/14 P F812

• RC10 PSY UI60204

     UP18/12/14 P F812

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.