A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool panel ADB2MEX 'DB2 Index Space Estimator' gives incorrect / invalid results for non-unique partitioning index. Examples: Field 'Key length' reports decimal values and 'DASD estimates:' are too small.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Admin Tool v72. * **************************************************************** * PROBLEM DESCRIPTION: The space calculation is using * * FULLKEYCARD from SYSIBM.SYSINDEXPART * * for each part, should be using * * FULLKEYCARDF. Displaying a decimal * * value for the key length when it * * should be numeric only. * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** Modified the panel ADB2MEXG to fetch FULLKEYCARDF and modified exec ADB2MEX to discard AVGKEYLEN if the value is zero.
Problem conclusion
Incident is now resolved.
Temporary fix
Comments
APAR Information
APAR number
PK33657
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2006-10-26
Closed date
2008-12-15
Last modified date
2009-01-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK42504
Modules/Macros
ADB2MEX ADB2MEXG
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK42504
UP08/12/23 P F812
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":"7.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 January 2009