A fix is available
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
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