PH22700: EXECUTING OBJECT COMPARE WSL MAY CAUSE SQLCODE -669 DUE TO EXPLICIT DROP OF UTS TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The WSL created by Object Compare may include a DROP TABLE for a
  table that resides in a universal tablespace (UTS), which
  results in SQLCODE -669 (The object cannot be explicitly
  dropped) prior to Db2 12 FL506.  For Db2 12 FL506 and later, the
  DROP TABLE is successful, but SQLCODE -204 may be returned for
  a subsequent DROP TABLESPACE of the corresponding tablespace.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of Db2 Object Comparison Tool for  *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: SQLCODE -669 due to DROP TABLE being    *
  *                      generated for a table that resides in   *
  *                      a Universal Table Space (UTS) prior to  *
  *                      Db2 12 function level 506. After        *
  *                      Db2 12 function level 506 is activated, *
  *                      SQLCODE -204 is issued because the      *
  *                      DROP TABLE drops the table space also.  *
  ****************************************************************
  WSL contains a DROP TABLE for a table that resides in a UTS.
  Before Db2 12 function level 506, DROP TABLE fails with
  SQLCODE -669 because the table space must be dropped, not the
  table. After Db2 12 function level 506, the DROP TABLE is
  successful, but the later DROP TABLESPACE receives
  SQLCODE -204 because the prior DROP TABLE drops the table space
  as well. The SQLCODE -204 will typically be ignored and the
  final result is as expected.
  

Problem conclusion

• To resolve the reported problem, only the DROP TABLESPACE will
  be generated if the table resides in a UTS.
  
  Search keywords: SQLCODE204N SQLCODE669N FL506 SQLSTATE42917
  

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:

  UI71915

Modules/Macros

• ADB2CMR
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI71915

     UP20/11/02 P F010

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.