A fix is available
APAR status
Closed as program error.
Error description
When using DB2 Object Comparison Tool for z/OS, objects created prior to DB2 9 will have OWNER = ''. Comparison will find the difference and will show message Compare table source(Source.xxxxx) and target(Target.xxxxx) (D)Field OWNER changed from '' to <Target> . Should be: (D)Field OWNER changed from '' to <Source>
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool for * * z/OS who compare objects created prior to * * DB2 9 with objects created with DB2 9 or * * later. * **************************************************************** * PROBLEM DESCRIPTION: Two issues have been reported: * * * * 1. DB2 Object Comparison Tool compares * * a blank owner from objects created * * prior to DB2 9, causing the drop and * * recreate of the object. * * * * 2. In the DB2 Object Comparison Report * * the target owner is used instead of * * the source owner when the difference * * is being reported: * * * * (D)Field OWNER changed from '' to * * xxx * * ==> This is target tbcreator * * NOT OWNER * **************************************************************** * RECOMMENDATION: * **************************************************************** Two issues have been reported: 1. DB2 Object Comparison Tool compares a blank owner from objects created prior to DB2 9, causing the drop and recreate of the object. 2. In the DB2 Object Comparison Report the target owner is used instead of the source owner when the difference is being reported.
Problem conclusion
1. DB2 Object Comparison Tool has been updated to not compare a blank owner. 2. The user specified masking for AUTHID which has the following hierarchy: AUTHID SQLID SCHEMA TBSCHEMA,IXSCHEMA OWNER DBOWNER,TSOWNER,TBOWNER,IXOWNER The DB2 Object Comparison Tool correctly applied the AUTHID mask to the source owner. The mask had the same value as the owner from target.
Temporary fix
Comments
APAR Information
APAR number
PM29924
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-01-05
Closed date
2011-04-01
Last modified date
2011-05-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CMF ADB2CMT
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK66440
UP11/04/08 P F104
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":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 May 2011