PM84474: REORG AUX YES ABENDED WITH RC00E40005 ON UNLOAD PHASE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Online REORG AUX YES SORTNUM 35 ran against a PBR UTS tablespace
    whose table has an BLOB(2M) column with inline length 7000.
    REORG tried to allocate extremely high volume of DAxxWKxx
    datasets and exhausted the SMS storage group for temp datasets:
    ICE083A D RESOURCES WERE UNAVAILABLE FOR DYNAMIC ALLOCATION OF
    WORK DATA SETS (970C).
    
    Even after RUNSTATS, REORG still failed with the same reason.
    Finally this problem bypassed by manually specified 8 DAxxWKxx
    datasets.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of REORG AUX YES   *
    *                 on table space with inline LOB.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: A REORG AUX YES on a table space with   *
    *                      an inline LOB column abended with       *
    *                      ABEND04E RC00E40005 and RC00E40347,     *
    *                      along with MSGICE083A because of space  *
    *                      unavailable for sort work data sets.    *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available.         *
    ****************************************************************
    A REORG with AUX YES ran on a base table space which contained
    a table with an inline LOB column.  REORG overestimated the
    average row length resulting in an ABEND04E RC00E40005 and
    RC00E40347, along with message ICE083A D RESOURCES WERE
    UNAVAILABLE FOR DYNAMIC ALLOCATION OF WORK DATA SETS (970C).
    This problem happened because the INLINE LOB length was
    calculated into the fixed column length.  If UTSORTAL=YES is
    used this can result in MSGDSNU3341I - CANNOT ALLOCATE SORT
    DATA SETS WITHIN 255 LIMIT.
    

Problem conclusion

  • REORG code has been modified to calculate the INLINE LOB length
    into the variable column length.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM84474

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-11

  • Closed date

    2013-04-23

  • Last modified date

    2013-06-04

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

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

    UK93705

Modules/Macros

  •    DSNURFTB
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK93705

       UP13/05/09 P F305

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

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM84474

Modified date:

2013-06-04

Translate my page

Machine Translation

Content navigation