PM23880: MQT MISSING AFTER COMPARE OF A CREATE TABLE / ALTER TABLE ADD MATERIALIZED QUERY DDL SET.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Object Comparison Tool for z/OS does not preserve the
  MQT attribute of a table after a comparison when the original
  DDL contains a CREATE TABLE / ALTER TABLE ADD MATERIALIZED QUERY
  construct.
  
  The resulting DDL contains only the CREATE TABLE syntax.
  DB2 Administration for z/os also being updated for DTC and
  Merge components.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison           *
  *                 Tool for z/OS who compare tables             *
  *                 which have been altered to materialized      *
  *                 query tables (MQT).                          *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Object Comparison Tool          *
  *                      did not support the 'ALTER TABLE        *
  *                      ADD materialized query' statement.      *
  ****************************************************************
  * RECOMMENDATION: Apply The PTF.                               *
  ****************************************************************
  The DB2 Object Comparison Tool did not support the
  'ALTER TABLE ADD materialized query' statement.
  

Problem conclusion

• The DB2 Object Comparison Tool has been updated
  to support the following SQL statements:
  
  ALTER TABLE ADD materialized query
  ALTER TABLE DROP materialized query
  ALTER TABLE ALTER materialized query.
  

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

•    ADBCCMM  ADBCDTS  ADB2CMF  ADB2CMP  ADB2CMR
  ADB2CMS  ADB2CMT  ADB2PA   ADB2RE   ADB2REE  ADB2REG  ADB2REZ
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK63573

     UP11/02/06 P F102

• R720 PSY UK63574

     UP11/02/06 P F102

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.