PH29581: LOAD PRESORT PARALLEL INCORRECTLY ISSUES DSNU345I FOR UNIQUE INDEX KEY DUPLICATES KEY

Obtain the fix for this APAR.

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 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.