A fix is available
APAR status
Closed as program error.
Error description
The DB2 Objection Comparison Tool, when using IGNORE options SYSTABLEPART:PQTY,SQTY SYSINDEXPART:PQTY,SQTY will alter the tablespace changing SECQTY to 0 and message below will appear in the Comparison Report: (A)Field SECQTY changed from 48 to 0
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Object Comparison Tool for * * z/OS who compare table spaces or indexes * * and specify an IGNORE for the secondary * * space allocation. * **************************************************************** * PROBLEM DESCRIPTION: In DB2 Object Comparison Tool for z/OS, * * when using the IGNORE options: * * * * SYSINDEXPART:SQTY * * * * and a difference is found in * * SYSINDEXPART.SECQTY, the DB2 Object * * Comparison Tool will alter the index * * changing the SECQTY value to 0. * **************************************************************** * RECOMMENDATION: * **************************************************************** In DB2 Object Comparison Tool for z/OS, when using the IGNORE options: SYSINDEXPART:SQTY and a difference is found in SYSINDEXPART.SECQTY, the DB2 Object Comparison Tool will alter the index changing the SECQTY value to 0.
Problem conclusion
Currently, when using the IGNORE function to ignore secondary space allocation for table spaces or indexes, because of the dependency between SQTY and SECQTYI fields on SYSTABLEPART and SYSINDEXPART that are updated by DB2, the user has to specify both SQTY and SECQTYI IGNORE options, like this: SYSTABLEPART: SQTY,SECQTYI SYSINDEXPART: SQTY,SECQTYI This is explained in the DB2 Administration Tool and DB2 Object Comparison Tool's User's Guides. This problem will happen if only one of the two is specified as IGNORE options. After this APAR is applied, specifying either SQTY or SECQTYI IGNORE options will cause the secondary space allocation to be ignored. An update is needed in the DB2 Administration Tool's User's Guide and the DB2 Object Comparison Tool's User's Guide. Currently in the 'Overview of Ignores' topic of the DB2 Administration Tool for z/OS's User's Guide and in the 'Ignore fields' topic of the DB2 Object Comparison Tool User's Guide, there is a paragraph which provides an example of SQTY and SECQTYI, indicating the dependency between these two fields. This paragraph needs to be updated, as the fix for this APAR removes the restriction of specifying both SQTY and SECQTYI ignore options for secondary space allocation. The paragraph to be updated is: Another type of dependency is between the SQTY and SECQTYI fields on SYSTABLEPART and SYSINDEXPART that are updated by DB2. If secondary quantity is to be ignored, specify both fields or use the generic SPACE specification. It will be updated to: Another type of dependency is between the SQTY and SECQTYI fields on SYSTABLEPART and SYSINDEXPART that are updated by DB2. If the secondary quantity is to be ignored, specify both fields or use the generic SPACE specification. If only one value is specified to be ignored, the tool will ignore both values.
Temporary fix
Comments
APAR Information
APAR number
PM35402
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-03-22
Closed date
2011-08-11
Last modified date
2011-09-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK70722
Modules/Macros
ADB2IGN
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK70722
UP11/08/16 P F108
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 September 2011