PK86601: MESSAGE (D)COLUMN DB2_GENERATED_ROWID_FOR_LOBS DROPPED RESULTS IN TABLE WITH LOB COLUMNS BEING DROPPED AND RECREATED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS issues a message:
  Compare table source(creator.table) and target(creator.table)
    (D)Column DB2_GENERATED_ROWID_FOR_LOBS dropped
    Auxiliary table creator.table1 processed
    Auxiliary table creator.table2 processed
    Auxiliary table creator.table3 processed
    Table creator.table RESTRICT ON DROP will be removed
    Table creator.table will be dropped
    Table will be recreated
  .
  for a table with LOB columns which has no changes made to it.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users  of  Change  Management  and  Object   *
  *                 Compare  Ver 7.2  who  compare  LOB tables   *
  *                 defined with DDL to their catalog versions   *
  *                 that have defaulted ROWID columns.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The ROWID column is reported as dropped *
  *                      and the table is dropped and recreated. *
  *                      message:                                *
  *                       Compare table source(creator.table)    *
  *                       and  target(creator.table)             *
  *                                                              *
  *                      (D)Column DB2_GENERATED_ROWID_FOR_LOBS  *
  *                         dropped                              *
  *                                                              *
  *                       Auxiliary table creator.table1         *
  *                                 processed                    *
  *                       Auxiliary table creator.table2         *
  *                                 processed                    *
  *                       Auxiliary table creator.table3         *
  *                                 processed                    *
  *                                                              *
  *                      Table creator.table RESTRICT ON DROP    *
  *                      will be removed Table creator.table,    *
  *                      will be dropped Table will be           *
  *                      recreated.                              *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  In this situation, there should be no changes to the table.
  

Problem conclusion

• A change was made to Object Compare to correct this processing.
  

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

•    GOC2CMF  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK49454

     UP09/08/27 P F908

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.