PH45500: PERFORMANCE IMPROVEMENT FOR UNLOAD FROM A GLOBAL IMAGE COPY INTO A SINGLE FILE

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• The elapsed time of an unload fulfilling all the following
  conditions has been decreased:
  - the data is unloaded from an image copy containing the data
  from a whole table space (from all partitions if the table space
  is partitionned)
  - the input image copy is not a FlashCopy
  - the data is unloaded into a single output dataset
  
  The performance improvement is more significant if the image
  copy processing requires the input image copy to be sorted, i.e.
  if Db2 HPU automatically determines that the processing for an
  INLINE or a FROMCOPYTOCOPY image copy applies or if it is
  directed to apply such a processing.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The elapsed time of an unload           *
  *                      fulfilling all the following conditions *
  *                      has been decreased:                     *
  *                      - the data is unloaded from an image    *
  *                      copy containing the data from a whole   *
  *                      table space (from all partitions if the *
  *                      table space is partitioned)             *
  *                      - the input image copy is not a         *
  *                      FlashCopy                               *
  *                      - the data is unloaded into a single    *
  *                      output dataset                          *
  *                                                              *
  *                      This performance improvement is more    *
  *                      significant if the image copy           *
  *                      processing requires the input image     *
  *                      copy to be sorted, i.e. if Db2 HPU      *
  *                      automatically determines that the       *
  *                      processing for an INLINE or a           *
  *                      FROMCOPYTOCOPY image copy applies or if *
  *                      it is directed to apply such a          *
  *                      processing.                             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Performance improvement for unload from a global image copy into
  a single file.
  

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

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI80220

     UP22/04/28 P F204

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.