A fix is available
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 number
PM23880
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
720
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-10-05
Closed date
2010-12-29
Last modified date
2011-03-02
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
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 March 2011