A fix is available
APAR status
Closed as program error.
Error description
Running a CM BATCH COMPARE gets error message in the ANALYZE during MERGE: MERGE REPORT ============ ADB8014E An attempt was made to alter the table attributes of a table that d not contain the TB record to be changed. ADB8057I Object details at the time of error: Operation : 50 Row type : TB Object qualifier: DB2ADM Object name : TSPACE_EXCEPTION Procedure : merge_tables The DDL contains a CREATE TABLE/RENAME sequence and it appears that the compare process generates change statements which refer to the "new" table name before the RENAME actually takes place. This leads to the problem situation.
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Object Comparison Tool * * for z/OS who use Change Management * * with compare source containing the * * RENAME TABLE statement. * **************************************************************** * PROBLEM DESCRIPTION: When comparing a source containing * * the RENAME TABLE statement and * * some other change(s) to the * * same TABLE being renamed, the * * change is registered and analyzed, * * Change Management encounters * * error ADB8014E / msgadb8014e. * **************************************************************** * RECOMMENDATION: * **************************************************************** When a source contains a RENAME TABLE statement and some other change(s) to the same TABLE being renamed, Change Management encounters error ADB8014E / msgadb8014e and information message ADB8057I / msgadb8057i: ADB8014E An attempt was made to alter the table attributes of a table that does not contain the TB record to be changed. ADB8057I Object details at the time of error: Operation : 50 Row type : TB Object qualifier: >table_schema< Object name : >table_name< Procedure : merge_tables
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI71909
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-08
Closed date
2017-03-02
Last modified date
2017-04-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CMT ADB2CMU
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI45180
UP17/03/07 P F703
RB20 PSY UI45181
UP17/03/07 P F703
RC10 PSY UI45191
UP17/03/07 P F703
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":"11.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 April 2017