A fix is available
APAR status
Closed as program error.
Error description
Object Compare is generating incorrect results on table based on Unicode and DB2 Default Handling option is set to Remove. GOC2CMP
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Object Comparison Tool who use * * DFSMS compression on version files and are * * getting a 213-C8 abend. * **************************************************************** * PROBLEM DESCRIPTION: GEN and the DDL reader opens the * * version file for update which isn't * * allowed on DFSMS compressed data sets. * * Admin/OC jobs will receive an S213-C8 * * abend if the version file data sets * * are defined with DFSMS compression. * * When V71 version files used in V72 * * compare, results in DFSORT failure * * due to incorrect version count and * * results in following error: * * ADBC010E - Sort of BASEIN records * * failed * * GOCC002E - Severe error. Compare * * terminates * * When Old version files (created before * * count) are used in compare results in * * RC=00CA issue, with oncode 340, size * * condition . * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** Version files are compressed internally and should not be created with DFSMS compression because GEN and the DDL reader opens them for update which isn't allowed on DFSMS compressed data sets. Admin/OC jobs will receive S213-C8 abends if the version file data sets are defined with DFSMS compression. V71 version files used in V72 compare results in DFSORT failure, due to differences in mapping of record count field in V71 and V72 verion header record. For all older version files (before count),compare sets the record count to zero.
Problem conclusion
The following limitation has been added for version files in Admin/OC: Version files are compressed internally and should not be created with DFSMS compression because GEN and the DDL reader opens them for update which isn't allowed on DFSMS compressed data sets. Admin/OC jobs will receive S213-C8 abends if the version file data sets are defined with DFSMS compression The problem has been fixed in V7.2.
Temporary fix
Comments
APAR Information
APAR number
PK66033
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
Reported release
720
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-05-13
Closed date
2008-10-08
Last modified date
2008-11-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBCDTS
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK40537
UP08/10/16 P F810
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:
04 November 2008