PM91822: UNNECESSARY DROP/CREATE BASE TABLE STATEMENTS ARE GENERATED IN CHANGES FILE, WHEN ALT TABLE WITH MQT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Unnecessary DROP/CREATE base table statements are generated in
  CHANGES file, when ALT table with MQT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool      *
  *                 for z/OS who include Materialized Query      *
  *                 Tables (MQT) in the compare process.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: If a table referenced in a Materialized *
  *                      Query Table was altered, Object Compare *
  *                      dropped and recreated both tables       *
  *                      instead of dropping the MQT, altering   *
  *                      the referenced table, and re-creating   *
  *                      the MQT.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If a table referenced in a Materialized Query Table was
  altered, Object Compare dropped and recreated both tables
  instead of dropping MQT, altering the referenced table, and
  re-creating the MQT.
  

Problem conclusion

• 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

• ADB2CMF  ADB2CMP  ADB2CMR  ADB2CMT
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK97937

     UP13/09/28 P F309

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.