A fix is available
APAR status
Closed as program error.
Error description
Customer has run the following utility: REBUILD INDEX(XXX.TSXXX002) SORTKEYS SORTNUM 84 STATISTICS UPDATE ALL KEYCARD And he has received the following error: ICE000I 0 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 19:39 ON THU APR 22, 2010 - SORT FIELDS= (00007.0,00006.0,A,00001.0,00005.0,A),FORMAT=BI,FILSZ=E9999* 99999999999,DYNALLOC=(,84) ICE122A C FILSZ VALUE INVALID
Local fix
Customer has add this JCL card with all parameters of SORT, before the SYSIN card: //DFSPARM DD * SORT FIELDS=(00007.0,00006.0,A,00001.0,00005.0,A), FORMAT=BI,FILSZ=E099999999999999 //SYSIN DD * REBUILD INDEX (XXX.TSXXX00X) and with this, the error did not occur.
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS * * REBUILD utility users. * **************************************************************** * PROBLEM DESCRIPTION: DFSORT MSGICE122A FILSZ VALUE INVALID * * and ABEND04E RC00E40005 from REBUILD * * INDEX on a simple or segmented table * * space. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available. * **************************************************************** A REBUILD INDEX was run on a segmented table space with over 14 million pages in the table space. An error in a calculation computing an approximate number of rows in the table space caused the utility to pass FILSZ=999999999999999 to DFSORT. This caused DFSORT to issue MSGICE122A FILSZ VALUE INVALID and terminate with return code 16, which caused the utility ABEND04E RC00E40005.
Problem conclusion
REBUILD has been changed to calculate the estimate of the number of rows using 8 byte variables to avoid the error.
Temporary fix
Comments
APAR Information
APAR number
PM13822
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-05-05
Closed date
2010-06-02
Last modified date
2010-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK57545 UK57546
Modules/Macros
DSNUCINM
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
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":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 July 2010