PI56490: DB2 OBJECT COMPARISON TOOL BETTER MESSAGES WHEN TABLE COLUMNS REORDERED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Compare returned this report when the source had two new
  columns and two columns in a different order then the target:
  
  Compare table source(BRADF.TBL56119) and target(BRADF.TBL56119)
    (D)Complex column change/insert/delete
    (D)Column COLE added
    (D)Column COLF added
  
  This APAR to improve messages.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool for      *
  *                 z/OS who compare two tables, where some      *
  *                 columns in a table are reordered and at      *
  *                 the same time some columns are newly         *
  *                 inserted or deleted.                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 Object Comparison Tool for z/OS     *
  *                      compare report is not clear when some   *
  *                      columns in a table are reordered and    *
  *                      some columns are newly inserted or      *
  *                      deleted. Following is the report:       *
  *                                                              *
  *                      Compare table source(xxx.table1) and    *
  *                              target(xxx.table1)              *
  *                        (D)Complex column change/insert/      *
  *                                                 delete       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Compare report is not clear.
  

Problem conclusion

• Problem has been resolved. Compare report is changed
  as below:
  
  Compare table source(xxx.table1) and target(xxx.table1)
    (D)Complex column change including column reorder and added
       and/or deleted columns.
    (D) Column >column_name< reordered
    (D) Column >column_name< reordered
  

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:

  UI40294 UI40295

Modules/Macros

•    ADB2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• RB10 PSY UI40294

     UP16/08/31 P F608

• RB20 PSY UI40295

     UP16/08/31 P F608

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.