PK42818: REORG ABEND X'00E40347'

A fix is available

 

APAR status

  • Closed as program error.

Error description

  • DSNU050I 242 18:47:59.47 DSNUGUTC - REORG TABLESPACE
    BDAP1.SHAPC LOG NO SORTDATA SORTDEVT 3390 SORTKEYS
    NOSYSREC STATISTICS TABLE ALL SAMPLE 30 INDEX(ALL) KEYCARD
    DSNU1160I 242 18:48:00.15 DSNURPRD - PARTITIONS WILL BE
    UNLOADED/RELOADED IN PARALLEL, NUMBER OF TASKS = 7
    DSNU395I 242 18:48:00.15 DSNURPRD - INDEXES WILL BE BUILT IN
    PARALLEL, NUMBER OF TASKS = 1
    DSNU397I 242 18:48:00.15 DSNURPRD - NUMBER OF TASKS
    CONSTRAINED BY VIRTUAL STORAGE BELOW
    DSNU397I 242 18:48:00.15 DSNURPRD - NUMBER OF TASKS
    CONSTRAINED BY CPUS
    DSNU016I 242 18:50:05.11 DSNUGSAT - UTILITY BATCH MEMORY
    EXECUTION ABENDED, REASON=X'0000'
    DSNU016I 242 18:50:07.32 DSNUGBAC - UTILITY BATCH MEMORY
    EXECUTION ABENDED, REASON=X'00E40347'

Local fix

  • N/A

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS V9 utility users *
    ****************************************************************
    * PROBLEM DESCRIPTION: REORG TABLESPACE abends with an *
    * ABEND04E RC00E40347 when DFSORT abends *
    * due to lack of sort work space caused *
    * by an average row length that was too *
    * small and an inaccurate FILSZ *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available *
    ****************************************************************
    REORG TABLESPACE was run on a partitioned tablespace with some
    partitions empty and others containing data. Some of the
    partitions were also compressed. As the REORG was processing
    using parallel tasks, a miscalculation in the approximate number
    of rows for that task caused DFSORT to not calculate the correct
    amount of storage for its working dataset for that task. This
    resulted in DFSORT abending and issuing MSGICE185A - DFSORT
    TERMINATED WITH S13E.

Problem conclusion

  • REORG code has been changed to better calculate the approximate
    number of rows that a particular subtask will process.
    D/T3390-9

Temporary fix

Comments

APAR Information

  • APAR number

    PK42818

  • 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

    2007-04-05

  • Closed date

    2007-08-15

  • Last modified date

    2008-10-14

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UK28287

Modules/Macros
DSNURPUI          

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK28287

       UP07/09/01 P F708

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.

Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

910

Reference #:

PK42818

Modified date:

2008-10-14

Translate my page

Machine Translation

Content navigation