PM93668: WHEN TARGET TABLESPACE IS EXCLUDED, DROP TABLE STATEMENT IS INCORRECTLY GENERATED FOR TABLE IN EXPLICIT PARTITIONED OR PBG.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Object Comparison Tool for z/OS.
  When target tablespace is EXCLUDED, DROP TABLE statement
  is incorrectly generated for table in explicit partitioned or
  PBG tablespace in CHG file, which causes SQLCODE -669.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who has excluded a Partition-By-    *
  *                 Growth (PBG) or Partition-By-Range (PBR)     *
  *                 table space and its table needs to be        *
  *                 dropped.                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: When a partitioned table is to be       *
  *                      dropped and its table space is          *
  *                      excluded, DB2 will issue a              *
  *                      SQLCODE=-669 / SQLCODEN669              *
  *                      when it tries to drop the table:        *
  *                                                              *
  *                      DSNT408I SQLCODE = -669, ERROR:         *
  *                      THE OBJECT CANNOT BE EXPLICITLY         *
  *                      DROPPED. REASON 0001                    *
  *                      DSNT418I SQLSTATE   = 42917             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Object Compare should not explicitly drop a partitioned table.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UK97937

Modules/Macros

• ADB2CMF  ADB2CMP  ADB2CMR  ADB7000
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK97937

     UP13/09/28 P F309

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.