A fix is available
APAR status
Closed as program error.
Error description
DB2 Administration Tool for z/OS ANALYZE process does not handle correctly the CHG file that contains both DROP SYNONYM and CREATE VIEW statements
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS and DB2 Object Comparison * * Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: DB2 Administration Tool for z/OS * * ANALYZE process does not handle * * correctly the Change (CHG) file * * that contains both DROP SYNONYM * * and CREATE VIEW statements when * * the SYNONYM and VIEW have the * * same name. * **************************************************************** * RECOMMENDATION: * **************************************************************** Program does not identify objects with a duplicate name before generating messages: DB2 Administration Tool for z/OS Version 11, Release 1: ADB7176E Synonym >syn_name< for >syn_creator< is also found as a >obj_type<. ADB7177E >obj_creator.obj_name< is also found as a >obj_type<. ADB7178E Some objects have duplicate names after compare. DB2 Administration Tool for z/OS Version 11, Release 2: ADB7128E Some objects have duplicate names after compare. ADB7178E Synonym >syn_name< for >syn_creator< is also found as a >obj_type<. ADB7179E >obj_creator.obj_name< is also found as a >obj_type< and the job fails with a Return Code 8 / RC8, for example when analyzing the following statements: DROP SYNONYM TB0001; CREATE VIEW >schema<.TB0001 ADB7176E Synonym >syn_name< for >syn_creator< is also found as a >obj_type<.
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PI55246
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-01-12
Closed date
2016-05-02
Last modified date
2016-06-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI37470 UI37471
Modules/Macros
ADB2CMP ADB7000
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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 June 2016