IBM Support

PK45376: DSNTIJNE JOB ABENDS WITH A SORT CAPACITY ERROR WHEN REORGING SPT01 DURING ENFM 07/06/01 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • DFSORT ABENDU010 or MSGICE046A SORT CAPACITY EXCEEDED might
    occur on job DSNTIJNE step ENFM0187 when reorganizing/converting
    directory tablespace SPT01 .
    FILSZ of 0 passed by DB2 to DFSORT may cause this error.
    Sort doesn't necessarily abend because of this but it could.
    Additional Symptoms:
    DSNURFIT +05BA ABEND0C4 PIC38  when object in LISTDEF
    of REORG statement is not found.
    
    DB2MIGV9/K  DB2MIGV8/K
    

Local fix

  • add
    //DFSPARM DD *
          OPTION FILSZ=Ennnnnnn
    where xxxxx is a good estimate
    of number of rows to sort.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS V8 utility users with       *
    *                 PTF (UK21909) applied and all DB2 z/OS V9    *
    *                 utility users.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: During Enabling New Function Mode       *
    *                      (enfm) DSNTIJNE REORG with ptf UK21909  *
    *                      applied, MSGICE046A SORT CAPACITY       *
    *                      EXCEEDED occurrs when REORGing SPT01.   *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    APAR PK37666 used the 'old' (compatability mode) page size
    when attempting to calculate the FILSZ (estimated number of
    rows) for the REORG of particular catalog tablespaces.  There
    exists a path wherein the 'new' (enfm) maximum row length was
    used with the 'old' (cm) page size in the rows per page
    calculation.  Since the 'new' maximum row length was greater
    than the 'old' page size, a value of zero (0) was calculated as
    the rows per page and, when multiplied by the number of pages,
    an estimate of zero (0) was calculated for FILSZ.  When this
    value was passed to SORT, a sort capacity error occurred and
    MSGICE046A SORT CAPACITY EXCEEDED was issued.
    

Problem conclusion

  • REORG has been modified to use the 'old' maximum record length
    when calculating FILSIZ during enfm processing.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK45376

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2007-05-17

  • Closed date

    2007-09-28

  • Last modified date

    2011-12-01

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

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

    UK29761 UK29762

Modules/Macros

  •    DSNURFIT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK29761

       UP07/10/17 P F710

  • R910 PSY UK29762

       UP07/10/17 P F710

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.



Document information

More support for: DB2 for z/OS

Software version: 810

Reference #: PK45376

Modified date: 01 December 2011


Translate this page: