A fix is available
APAR status
Closed as program error.
Error description
Crossloader utility (load by cursor) sporadically gets abend0C4 in DSNUGSDA +539C (at level UK83424). Analysis of the dump shows that this happens when positioning on the SORTOUT dataset which should have the foreign keys that need to be read to check for violations. It looks to be a timing issue .
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 for z/OS users of the LOAD * * utility involving tables with unique indexes * * and referential integrity, with parallel * * index build. * **************************************************************** * PROBLEM DESCRIPTION: AE FIX COMPLETION FOR PM84395 * * * * ABENDS0C4 DSNUGSDA OFFSET539C during * * the ENFORCE phase of a LOAD INCURSOR * * on a table with unique indexes and * * referential integrity. * **************************************************************** * RECOMMENDATION: Apply corrective PTF when available * **************************************************************** AE FIX COMPLETION FOR PM84395 A LOAD INCURSOR utility with parallel index build was run on a table space with unique indexes and referential integrity (RI). The utility abended in the ENFORCE phase with an ABEND0C4 in DSNUGSDA +x'539C'. The abend occurred when LOAD attempted to position on the SORTOUT data set to read in the foreign keys with data set positioning information that was all zeroes. During the SORTBLD phase, the SYSUT1 data set is opened. This open acquires a new data set checkpoint control block, copies the old block into the new, updates each entry within the block with the new address and frees the old checkpoint block. There is a timing window (particularly with small amounts of data) where a checkpoint can occur for the SORTOUT data set just prior to the creation of the new checkpoint block during the SYSUT1 open, causing SORTOUT positioning data to be lost. Also, if the freed checkpoint storage is immediately reused, the LOAD can abend in the SORT phase with ABEND0C4 in ICETRYB +x'1D76' with ABEND04E RC00E40347 and other possible SORT related abends. Additional Keywords: OFFSET1D76 cross-loader crossloader
Problem conclusion
LOAD code has been modified to open the SYSUT1 data set prior to the attachment of the subtasks in the SORTBLD phase.
Temporary fix
Comments
APAR Information
APAR number
PM89197
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-05-16
Closed date
2013-06-21
Last modified date
2013-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK95336
Modules/Macros
DSNUGSDA DSNURPIB DSNURPPL DSNURPTB
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RA10 PSY UK95336
UP13/07/10 P F307
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:
02 August 2013