PM15760: WHEN LOAD DATA RESUME YES SHRLEVEL CHANGE IS CANCELLED IN RELOADPHASE AN ABENDU0046 IS RECEIVED WHEN THE JOB IS RERUN.

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • LOAD DATA RESUME YES SHRLEVEL CHANGE
    INTO TABLE DB2C.CDPTKTN7 WHEN(240:242)='001'
       (KONTONR POSITION(3) CHAR(19),
        REP_KEY POSITION(243) CHAR(24))
    Later the job was re-submitted to load records after the last
    commit point. This latter job abended in DFSORT with U0046
    and no information was written to UTPRINT DD. No rows
    were loaded because all records on the input file were
    duplicates (index violation).
    The joblog shows the reason for the ABENDU0046:
    ICE046A 0 SORT CAPACITY EXCEEDED - RECORD COUNT 31908
    ICE253I 0 RECORDS SORTED - PROCESSED: 31908, EXPECTED: 0
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for z/OS V8 and DB2 9 for z/OS       *
    *                 users of LOAD SHRLEVEL CHANGE encountering   *
    *                 duplicate key errors.                        *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E40005 and MSGDSNU044I -   *
    *                      ERROR FROM SORT COMPONENT RC=16 during  *
    *                      a LOAD SHRLEVEL CHANGE with many        *
    *                      duplicate key errors and no DISCARD     *
    *                      processing.                             *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available          *
    ****************************************************************
    A LOAD SHRLEVEL CHANGE utility encountered many duplicate key
    errors as evident in the numerous MSGDSNU1117I - UNIQUE INDEX
    KEY DUPLICATES KEY OF INDEXED RECORD messages.  The LOAD abended
    with an ABEND04E RC00E40005 with MSGDSNU044I - ERROR FROM SORT
    COMPONENT RC=16.  Discard processing was not active.
    
    The LOAD utility abended while attempting to sort the error
    information records used in the LOAD REPORT SUMMARY MSGDSNU399I
    - LOAD UTILITY ERROR SUMMARY REPORT.  A zero file size was
    passed to sort.  If discard processing is active, the correct
    discard value is passed.  For a LOAD SHLEVEL CHANGE, without
    DISCARD processing, the value passed to sort was zero, leading
    to the abend.
    
    A similar problem can occur during a LOAD SHRLEVEL CHANGE with
    no DISCARD processing with referential integrity errors (RI).
    
    The UTILITY GUIDE AND REFERENCE manual has been updated to
    remove the indication that a REPORT phase is not applicable to
    a LOAD SHRLEVEL CHANGE as seen in the SHRLEVEL CHANGE
    description of the LOAD utility.
    
    Additional Keywords:  FILSZ FILSZ=0000000 (FILSZ=0000000)
    

Problem conclusion

  • The LOAD utility has been modified to pass a file size value
    to the REPORT phase for a LOAD SHRLEVEL CHANGE with no DISCARD
    processing when duplicate key or refential integrity errors are
    found.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM15760

  • 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-06-07

  • Closed date

    2010-06-18

  • Last modified date

    2010-08-02

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

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

    UK58022 UK58023

Modules/Macros

  •    DSNURDER DSNURRSS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R810 PSY UK58022

       UP10/07/07 P F007

  • R910 PSY UK58023

       UP10/07/07 P F007

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:

9.1

Reference #:

PM15760

Modified date:

2010-08-02

Translate my page

Machine Translation

Content navigation