IBM Support

PM13822: REBUILD INDEX (THE TABLE HAS 64GB) RECEIVING ERROR ICE122A C FILSZ VALUE INVALID. FILSZ=E9999* AND NEXT LINE: 99999999999

A fix is available

Subscribe

You can track all active APARs for this component.

 

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

  • R810 PSY UK57545

       UP10/06/19 P F006

  • R910 PSY UK57546

       UP10/06/19 P F006

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