PM26567: ROWID CHANGED FROM GENERATED ALWAYS TO GENERATED BY DEFAULT IN DB2 OBJECT COMPARISON TOOL FOR Z/OS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Object Comparison Tool, when a table containing
  column ROWID defined with GENERATED ALWAYS is dropped/
  recreated, column ROWID redefined as GENERATED BY DEFAULT
  to preserve data.
  Option will be given to the customer to regenerate column
  ROWID as GENERATED ALWAYS.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 and the DB2 Object Comparison Tool for       *
  *                 z/OS who alter tables that have ROWID        *
  *                 or ROW CHANGE TIMESTAMP columns.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Object Comparison Tool       *
  *                      for z/OS, when a table containing       *
  *                      the column ROWID/TIMESTAMP is           *
  *                      defined with the GENERATED              *
  *                      ALWAYS option, the table is             *
  *                      dropped/recreated, and the              *
  *                      column ROWID/TIMESTAMP is               *
  *                      redefined as GENERATED BY               *
  *                      DEFAULT to preserve the data.           *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The DB2 Administration Tool for z/OS did not support the
  GENERATED ALWAYS option for ROWID or TIMESTAMP
  columns.
  

Problem conclusion

• The options will be given to the customer to regenerate
  column ROWID or TIMESTAMP as GENERATED ALWAYS.
  

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

•    ADBALT   ADBCHANG ADBCHAN7 ADBCHG01 ADBCHU12
  ADBEALT  ADBHC11A ADBH7P   ADBP7P   ADBSALT  ADB2CEX1 ADB2CMP
  ADB2CMR  ADB2CMT  ADB2C11A
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK63573

     UP11/02/06 P F102

• R720 PSY UK63574

     UP11/02/06 P F102

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.