PI94102: DB2 ADMIN TOOL - CMBATCH GENERATES INVALID DROP OF PGB TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When dropping a table space from one database and recreating in
  a different database, AOC will generate DROP TABLE statement
  although the table is dropped implicitly by dropping the table
  space via explicit DROP TABLESPACE statement. The DROP TABLE is
  not allowed for PGB tablespaces. The result from execution is
  SQLCODE -669 / SQLCODEN669.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS who use Change Management               *
  *                 Batch (CM Batch) function to import          *
  *                 and analyze change containing DROP           *
  *                 TABLESPACE statement and create              *
  *                 the same table space in a different          *
  *                 database with all dependent objects.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: CM Batch generates invalid drop of a    *
  *                      PGB table. The result from execution    *
  *                      is SQLCODE=-669 / SQLCODEN669.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When dropping a table space from one database and recreating
  in a different database, Compare generates DROP TABLE
  statement although the table is dropped implicitly by dropping
  the table space via explicit DROP TABLESPACE statement.
  

Problem conclusion

• The 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:

Modules/Macros

•    ADB2CMP  ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB20 PSY UI55509

     UP18/04/30 P F804

• RC10 PSY UI55510

     UP18/04/28 P F804

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.