PH23760: GENERATED LOAD CONTROL CARDS WITH IRRELEVANT DUPLICATE INTO TABLE CLAUSES WHEN UNLOADING FROM GLOBAL I 20/04/27 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the fix for PH20972/PB60747 has been
  applied, the LOAD control cards generated for an unload contain
  irrelevant duplicate INTO TABLE clauses.
  This occurs if the following conditions are full-filled:
  - the data is to be unloaded from an image copy (COPYDDN option)
  - the involved image copy is the global image copy of a
  partition-by-growth table space
  - the number of partitions to be unloaded is not equal to the
  MAXPARTITIONS attribute of the involved table space
  

Local fix

• if applicable, consider providing Db2 HPU with the DDL of the
  involved table space .
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix for PH20972/PB60747 has   *
  *                      been applied, the LOAD control cards    *
  *                      generated for an unload contain         *
  *                      irrelevant duplicate INTO TABLE         *
  *                      clauses.                                *
  *                                                              *
  *                      This occurs if the following conditions *
  *                      are fullfilled:                         *
  *                      - the data is to be unloaded from an    *
  *                        image copy (COPYDDN option)           *
  *                      - the involved image copy is the global *
  *                        image copy of a partition-by-growth   *
  *                        table space                           *
  *                      - the number of partiions to be         *
  *                        unloaded is not equal to the          *
  *                        MAXPARTITIONS attribute of the        *
  *                        involved table space                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After fix for PH20972, generated LOAD control cards with
  irrelevant duplicate INTO TABLE clauses when unloading from
  global IC from partition-by-growth table space.
  

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 INZTDSC  INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
  INZUTILL
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI69508

     UP20/05/22 P F005 {

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.