A fix is available
APAR status
Closed as program error.
Error description
LOAD PRESORT PARALLEL with single input data set incorrectly reports unique index key violations
Local fix
Remove the PARALLEL keyword
Problem summary
**************************************************************** * USERS AFFECTED: * * All Db2 12 for z/OS users of LOAD PRESORT * * PARALLEL with a single input data set. * **************************************************************** * PROBLEM DESCRIPTION: * * LOAD PRESORT PARALLEL with single * * input data set incorrectly reports * * DSNU345I unique index key violations * * and too few records processed and * * loaded. * **************************************************************** * RECOMMENDATION: * * Apply corrective PTF when available * **************************************************************** LOAD PRESORT PARALLEL with single input data set created multiple tasks for converting records and a single task for presorting the data. The communication between the convert subtasks and the presort subtask was setup incorrectly and resulted in a false detection of task termination. This caused an error in the buffer that held the data records and resulted in MSGDSNU345I - UNIQUE INDEX KEY DUPLICATES KEY FROM INPUT RECORD. In addition, if unique index keys do not exist, load may load incorrect records or duplicate records and an incorrect number of records processed and loaded. This problem only occurs for LOAD PRESORT PARALLEL. LOAD PRESORT without PARALLEL or LOAD PARALLEL without PRESORT do not have this problem.
Problem conclusion
Modified the setup of LOAD PRESORT PARALLEL for the aforementioned case.
Temporary fix
Comments
APAR Information
APAR number
PH29581
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2020-09-16
Closed date
2020-09-29
Last modified date
2020-11-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71821
Modules/Macros
DSNULPLD
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
RC10 PSY UI71821
UP20/10/08 P F010 ¢
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.0"}]
Document Information
Modified date:
31 March 2021