PH42284: MISSING ALTER TO DISABLE ARCHIVE ON TABLE BEFORE DROPPING TABLESPACE RETURNS SQLCODE = -478

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Before a tablespace is dropped, there needs to be an alter to
  DISABLE ARCHIVE on the table within that tablespace in order to
  allow that tablespace to be dropped. The following error will
  result if archiving is not disabled:
  
  ADB7955E ADBTEP2 DSNT408I SQLCODE = -478, ERROR: ALTER, DROP, OR
                   REVOKE AFFECTING OBJECT TYPE
  ADB7955E ADBTEP2 TABLE CANNOT BE PROCESSED BECAUSE OBJECT
                   >TABLENAME<
  ADB7955E ADBTEP2 OF TYPE TABLE IS DEPENDENT ON IT
  
  
  Keyword:  SQLCODE478N; msgadb7955e
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  *                 and Db2 Object Comparison Tool for z/OS      *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE = -478 results from a work      *
  *                      statement list (WSL) that explicitly    *
  *                      drops table spaces that contain an      *
  *                      archive and archive-enabled table pair  *
  *                      or a temporal and history table pair.   *
  ****************************************************************
  Importing and analyzing a change that explicitly drops
  table spaces that contain an archive and archive-enabled table
  pair or a temporal and history table pair might generate an
  incorrect WSL. This WSL does not disable the archiving or
  versioning before dropping the table space. Running this WSL
  results in the following SQL error:
  
  SQLCODE = -478, ERROR: ALTER, DROP, OR REVOKE AFFECTING OBJECT
  TYPETABLE CANNOT BE PROCESSED BECAUSE OBJECT >tbschema<.>tbname<
  OF TYPE TABLE IS DEPENDENT ON IT
  
  Keywords: SQLCODE478N; msgadb7955e
  

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:

  UI79297

Modules/Macros

• ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI79297

     UP22/02/17 P F202

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.