PM27643: COMPARE WHICH WILL DROP/RECREATE MQT DOES NOT CREATE MQT INDEX

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When OC calls ADB2REG with request 'CRETB' and the table is a
  partitioning MQT then ADB2REG reports missing VW record although
  this record has been supplied:
  Returning from ADB2REG. Records=0000
  RPT=>ADB1822E No sysviews row found for Create Materialized
  Query Table
  RPT=>
  ADB2REG return code=012 reason code=004
  RPT=>  Row types: TB TS LK LK LK EV*VW
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Object Comparison Tool for  *
  *                 z/OS who use a partitioning Materialized     *
  *                 Query Table ( MQT ).                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Object Comparison Tool for   *
  *                      z/OS when using a partitioning          *
  *                      Materialized Query Table ( MQT ) as     *
  *                      the source or target to compare, the    *
  *                      following error message is observed:    *
  *                                                              *
  *                      ADB1822E No sysviews row found for      *
  *                      Create Materialized Query Table         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  In the DB2 Object Comparison Tool for z/OS when using a
  partitioning Materialized Query Table ( MQT ) as the source or
  target to compare, the following error message is observed:
  
  ADB1822E No sysviews row found for Create Materialized Query
  Table
  

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

•    ADB2CMR  ADB2CMT  ADB2REP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK71423

     UP11/09/02 P F109

• R720 PSY UK71424

     UP11/09/02 P F109

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.