IBM Support

PM85850: LOAD INTO... PART X MAY ABND=0C4-00000038, LOC=DSNUT101.DSNURPLD+23BC

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A LOAD with fourteen INTO ... PART X clauses.   Thirteen of the
    SYSRECs are defined with  DD DUMMY . The job output shows
    PARTITIONS WILL BE LOADED IN PARALLEL, NUMBER OF TASKS = 6
    
    The first six parts processed (parts 1-6) had DD DUMMY input and
    completed showing
    NUMBER OF INPUT RECORDS PROCESSED=0
    
    The job abended processing the next set of 6 parts.  Five with
    DD DUMMY and one with an actual data set to load.
    
    
    The problem can occur when a load subtask loaded at least two
    partitions and the LRECL for first partition is smaller than
    the following ones'. It is because DB2 used to allocate the
    record work area for a subtask using the LRECL of the first
    partition as buffer length. When the record length of the next
    partition assigned to this task is bigger than the LRECL,
    then overlay will happen.
    
    Seen abends:
     ABND=0C4-00000010, LOC=DSNUT101.DSNUGSTB+1508
     ABND=0C4-00000038, LOC=DSNUT101.DSNURPLD+23C4
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS and DB2 10 for z/OS users *
    *                 of LOAD FORMAT DELIMITED with partition      *
    *                 parallelism                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C4 RC00000038 DSNURPLD OFFSET23C4 *
    *                      or ABEND0C4 RC00000010 DSNUGSTB         *
    *                      OFFSET1508 during a partition parallel  *
    *                      LOAD utility with FORMAT DELIMITED      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    User ran a LOAD FORMAT DELIMITED INTO TABLE PART X INDDN utility
    with partition parallelism. When one of the load subtask was
    assigned two partitions and the LRECL of the input dataset for
    the first partition is smaller than the second one, an overlay
    happened which caused ABENDS0C4 RC00000038 at
    DSNURPLD + x'23C4'.
    
    The reported problem was caused by the LOAD utility not
    allocating a sufficiently large enough work area for record
    processing.
    
    Additional symptom: DSNUGSTB + x'1508'
    

Problem conclusion

  • The LOAD partition parallelism code has been modified to
    allocate a sufficiently large work area for FORMAT DELIMITED
    processing
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM85850

  • 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-28

  • Closed date

    2013-06-13

  • Last modified date

    2013-07-03

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

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

    UK94931 UK94934

Modules/Macros

  • DSNURILD DSNURPLD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94931

       UP13/06/29 P F306

  • R910 PSY UK94934

       UP13/06/29 P F306

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":"10.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":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
03 July 2013