PK73198: ADMIN 720 RESTRICT THE USE OF CLONED TABLE, XML, HIDDEN COLUMN FOR DB2 V9 NFDB29

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN 720 RESTRICT THE USE OF CLONED TABLE, XML, HIDDEN COLUMN
  FOR DB2 V9.
  

Local fix

• APPLY PTF.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool V72 running *
  *                 on DB2 Version 9 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,BINARY *
  *                      or VARBIN) may lead to errors.          *
  *                                                              *
  *                      Rename database against an implicit     *
  *                      database is invalid.                    *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  ADMIN 720 RESTRICT THE USE OF CLONED TABLE, XML, HIDDEN COLUMN
  FOR DB2 V9 NFDB29 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.  Panel ADBP9000  "Compliance Check"  or
  message ADB522E:
   'The object has a characteristic which prevents changing the
    object using the DROP or DROP-SC action.'
  is displayed when such a condition occurs.
  

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

•    ADBH9000 ADBP9000 ADB21DA0 ADB21SA0 ADB21XA
  ADB27C   ADB27CA  ADB27CAA ADB27C0  ADB52
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R720 PSY UK41295

     UP08/11/21 P F811

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.