PK73206: OBJECT COMPARE 720, RESTRICT THE USE OF CLONED TABLES, XML AND HIDDEN CLOUMNS FOR DB2 V9 NFDB29

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• OBJECT COMPARE 720, RESTRICT THE USE OF CLONED TABLES, XML AND
  HIDDEN COLUMNS FOR DB2 V9
  

Local fix

• APPLY PTF
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of  DB2 Object  Compare Tool V7.2      *
  *                 running on DB2 V9 in new function mode.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: Data in clone tables  is not unloaded   *
  *                      when the base table is to be dropped.   *
  *                      Hidden columns  are not unloaded when   *
  *                      using HPU or DSNTIAUL.                  *
  *                                                              *
  *                      Incomplete or incorrect DDL is created  *
  *                      for objects  with clone tables, hidden  *
  *                      columns, or extended index types.       *
  *                                                              *
  *                      ALC operations against objects with new *
  *                      data types(XML, BIGINT, DECFLOAT, INARY *
  *                      or VARBIN) may lead to errors.   Rename *
  *                      database  against an implicit  database *
  *                      is invalid.                             *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  Objects with  certain DB2 V9 characteristics may not be
  completely unloaded nor their DDL completely recreated.
  

Problem conclusion

• Operations are disallowed against objects with the above
  characteristics. The following message is displayed when
  such a condition occurs:
  
  At least one of the following conditions exists that prevents
  continuing the operation.
  
    - a clone table exists
    - an implicitly hidden column exists
    - an extended index type exists
    - the database is implicitly created
    - an XML, BIGINT, DECFLOAT,
      BINARY or VARBIN data type
  
  The Object Compare step will end with a return code of 8.
  

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  GOC2CMP  GOC2CMR  GOC2CMS  GOC2CMT
  H25G720J
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK45542

     UP09/04/10 P F904

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.