PK99577: CHANGE MANAGEMENT MQT DROP TABLE AFTER DROP TABLESPACE RESULTS IN SQLCODEN204

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS produced a Change
  Management CHG file with a DROP TABLE for a MQT and a DROP
  DROP TABLESPACE for the tablespace containing the original table
  This resulted in a SQLCODEN204 error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Object Comparison Tool for z/OS *
  *                 who compare views and MQTs dependent on      *
  *                 other views.                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: The error 'Added table MQT_table-name   *
  *                      aready exists' is generated during      *
  *                      analyze for MQT dependent on a view     *
  *                      which is dropped/recreated .            *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The error 'Added table MQT_table-name already exists' is
  generated during analyze for MQT dependent on a view.
  

Problem conclusion

• The problem has been fixed.
  

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

•    GOC2CMP  GOC2CMT
  

Fix information

• Fixed component name

  DB2 OBJECT COMP

• Fixed component ID

  5697G6400

Applicable component levels

• R720 PSY UK53039

     UP09/12/25 P F912

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.