PM48292: SQLCODEN616 DROP LOB TABLESPACE / RENAMETB FOR AUX TABLE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The DB2 Object Comparison Tool for z/OS does not currently
  support changing the name of the AUX table by using the RENAMETB
  feature.
  A DROP TABLESPACE statement is issued for an AUX tablespace
  resulting in a SQLCODE -616 / SQLCODEN616.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who use the compare function to compare *
  *                 a set of objects that contain LOB objects.   *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool          *
  *                      for z/OS does not currently support     *
  *                      changing the name of the auxiliary      *
  *                      table by using the RENAMETB feature.    *
  *                      DB2 Object Compare generates a DROP     *
  *                      TABLESPACE statement for explicit       *
  *                      LOB tablespaces that are referenced     *
  *                      by an auxiliary table, and running      *
  *                      the APPLY job results in a              *
  *                      SQLCODEN616 / SQLCODE=-616:             *
  *                                                              *
  *                      DSNT408I SQLCODE = -616,                *
  *                      ERROR:  LOB TABLESPACE                  *
  *                      obj_name1 CANNOT BE                     *
  *                      DROPPED  BECAUSE IT IS                  *
  *                      REFERENCED BY AUX TABLE                 *
  *                      obj_name2.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The DB2 Object Comparison Tool for z/OS does not currently
  support changing the name of the auxiliary table by using the
  RENAMETB feature. DB2 Object Compare generates a DROP
  TABLESPACE statement for explicit LOB tablespaces that are
  referenced by an auxiliary table, and running the APPLY job
  results in a SELCODEN616 / SQLCODE=-616:
  
  DSNT408I SQLCODE = -616, ERROR:  LOB TABLESPACE
  obj_name1 CANNOT BE DROPPED BECAUSE IT IS
  REFERENCED BY AUX TABLE obj_name2.
  

Problem conclusion

Temporary fix

Comments

• Problem has been resolved. When DB2 Object Compare is supposed
  to generate a DROP TABLESPACE statement for an explicit LOB
  tablespace which is referenced by an auxiliary table, DB2
  Object Compare will end with a return code 8 and issue the
  following error message:
  
  '(E)A DROP statement is supposed to be generated
  for explicit LOB table space dbname.tsname which is
  referenced by AUX table tbowner.tbname. The AUX
  table must be dropped first'.
  
  The DB2 Object Comparison Tool for z/OS User's Guide will be
  updated to describe the current restriction on changing the
  name of the auxiliary table by using the RENAMETB feature.
  The paragraph to be updated is in Chapter 7 (Batch compare
  program), section 'Renamed objects' under topic 'Special
  considerations for comparing DB2 objects':
  
  Before update:
  Restriction: Rename of an implicit index is not
  supported.
  
  After update:
  Restriction: Rename of an implicit index is not
  supported. Rename of an auxiliary table is not
  supported.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK74157

Modules/Macros

•    ADB2CMP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK74157

     UP11/11/29 P F111

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.