PK58182: WHEN A PARTITIONED TS IS UNLOADED TO A UNIQUE OUTPUT FILE PER EACH PART, THEN DATA MAY BE REWRITTEN IN THE OUTPUT.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When a partitioned tablespace is unloaded, and when a unique
  OUTDDN output file is used for each partition, and if the OUTDDN
  DD card names contain the same 'base string' of characters, then
  data may be rewritten to the first of the two out files.
  For example, where the OUTDDN is defined for each partition as
  SYSREC1, SYSREC2, etc. up to SYSREC11, then SYSREC11 begins with
  the same seven characters as SYSREC1. In this case data intended
  for SYSREC11 may be written to SYSREC1 instead.
  

Local fix

• Code SYSREC1 as SYSREC01 instead so that it's 'base string'
  not a match to SYSREC11.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Unexpected mixing of data in output     *
  *                      data set may occur when an output       *
  *                      ddname is both a base ddname and a      *
  *                      suffixed ddname (used for unloading     *
  *                      partitioned table spaces with a         *
  *                      separate file per partition) PB 9110    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Module inzctrlh was changed to discard the use of a base ddname
  as a target of unloading per partition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK32782

Modules/Macros

•    INZUTILB
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R310 PSY UK32782

     UP08/01/10 P F801

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.