PH23965: INCORRECT UNLOADED DATA AND POTENTIAL ABENDS878 WHEN UNLOADING FROM A GLOBAL IMAGE COPY WITH DDLDDN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the fix for PI95886 has been applied, Db2 HPU unduly
  produces more than one output data set and can terminate in
  ABEND due to the lack of memory (ABENDS878) when the following
  conditions are fullfilled:
  - the data is unloaded from the global image copy (COPYDDN
  option)  of a partitoned dataset
  - the DDL to be used is provided through the DDLDDN feature
  - the content of the DDLDDN data set describes a
  partition-by-growth table space with a MAXPARTITION attribute
  greater than one
  - the unload specifies an ORDER clause
  The exact number of unloaded data sets depends on the case as
  follows:
  - case 1: If NUMPARTS is not specified in the DDLDDN data set,
  the number of unloaded data sets is equal to the value specified
  for MAXPARTITIONS
  - case 2: if NUMPARTS is specified, the number of unloaded data
  sets is the minimum between NUMPARTS and the number of
  partitions in the image copy data set.
  

Local fix

• In the DDLDDN data set content, replace the value specified for
  NUMPARTS by the exact number of partitions cnotained in the
  image copy. The whole expected data will be unloaded into a
  single data set.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix for PI95886 has been      *
  *                      applied, Db2 HPU unduly produces more   *
  *                      than one output data set and can        *
  *                      terminate in ABEND due to the lack of   *
  *                      memory (ABENDS878) when the following   *
  *                      conditions are fullfilled:              *
  *                      - the data is unloaded from the global  *
  *                      image copy (COPYDDN option) of a        *
  *                      partitioned dataset                     *
  *                      - the DDL to be used is provided        *
  *                      through the DDLDDN feature              *
  *                      - the content of the DDLDDN data set    *
  *                      describes a partition-by-growth table   *
  *                      space with a MAXPARTITION attribute     *
  *                      greater than one                        *
  *                      - the unload specifies an ORDER clause  *
  *                                                              *
  *                      The exact number of unloaded data sets  *
  *                      depends on the case as follows:         *
  *                      - case 1: If NUMPARTS is not specified  *
  *                      in the DDLDDN data set, the number of   *
  *                      unloaded data sets is equal to the      *
  *                      value specified for MAXPARTITIONS       *
  *                      - case 2: if NUMPARTS is specified,     *
  *                      the number of unloaded data sets is the *
  *                      minimum between NUMPARTS and the number *
  *                      of partitions in the image copy data    *
  *                      set.                                    *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Incorrect unloaded data and potential  ABENDS878 when unloading
  from a global image copy with DDLDDN describing a
  partition-by-growth table space and request of output data set
  per partition
  

Problem conclusion

• Code has been changed to fix this problem
  

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

• INZ$$PRM INZCHECK INZSGEN  INZTDSC  INZTPMEM INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69029

     UP20/04/22 P F004

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.