PK78681: ADMIN DB2 V9 RESTRICT,CLONED TABLES,XML,HIDDEN COLUMNS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN DB2 V9 RESTRICT,CLONED TABLES,XML,HIDDEN COLUMNS.
  

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

•    ADB2RE   ADB2REE  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK45503

     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.