PM13742: INCORRECT OUTPUT GENERATED FOR PARTITIONED TABLESPACE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• HPU320 only: The LOAD statement generated by HPU may be
  incorrect where the unload of a partitoned table space is
  requested and one of the following sets of conditions are true:
  1 - A single output file is requested and either
      ULOPTNS(UNLDDN(NO) is specified or
      ULOPTNS(UNLDDN(YES)) is specified and the single output
      data set is defined by TEMPLATE specification
      (thus not involving the &PART variable)
  2 - One output data set per partition is requested by referring
      to TEMPLATE specification involving the &PART variable and
      ULOPTNS(UNLDDN(YES)) is specified.
  For case #1, the LOAD statement contains undesired PART options.
  For case #2, the LOAD statement contains useless duplicated
               LOAD DATA commands and TEMPLATE definitions.
  
  PB10609
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU320 only: The LOAD statement         *
  *                      generated by HPU may be incorrect where *
  *                      the unload of a partitoned table space  *
  *                      is requested and one of the following   *
  *                      sets of conditions are true:            *
  *                      1 - A single output file is requested   *
  *                       and either the settings specify        *
  *                       ULOPTNS(LOADINDDN(NO))                 *
  *                       or the settings specify                *
  *                       ULOPTNS(LOADINDDN(YES)) and the single *
  *                       output data set is defined by a        *
  *                       TEMPLATE specification (thus not       *
  *                       involving the &PART variable)          *
  *                      2 - One output data set per partition   *
  *                       is requested by refering to a TEMPLATE *
  *                       specification involving the &PART      *
  *                       variable and the settings specify      *
  *                       ULOPTNS(LOADINDDN(YES)).               *
  *                      In case #1, the LOAD statement contains *
  *                      undesired PART options. In case #2, the *
  *                      LOAD statement contains useless         *
  *                      duplicated LOAD DATA commands and       *
  *                      TEMPLATE definitions.                   *
  *                      PM 10609                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzrload module was changed to correctly handle the
  situation.
  

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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK58096

     UP10/06/24 P F006

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.