PH21368: AFTER FIX FOR APAR PH11624, LOW PERFORMANCE WHEN UNLOADING LOB IN SPANNED DATASET IN NATIVE MODE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the fix for APAR PH11624 has been applied, the
  performance of unloads run in native mode and requesting LOB
  data be unloaded into spanned data set (SPANNED YES option)
  significantly decreases.
  

Local fix

• If applicable, consider running the unload in SQL mode by
  specifying the DB2 FORCE option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix for APAR PH11624? has     *
  *                      been applied, the performance of        *
  *                      unloads run in native mode and          *
  *                      requesting LOB data be unloaded into    *
  *                      spanned data set (SPANNED YES option)   *
  *                      significantly descreases.               *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  ****************************************************************
  after fix for APAR PH11624, low performance when unloading LOB
  in SPANNED dataset in native mode
  

Problem conclusion

• Code has been changed to fix this problem.
  

Temporary fix

Comments

• ×**** PE20/03/26 FIX IN ERROR. SEE APAR PH23760  FOR DESCRIPTION
  

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 UI68215

     UP20/03/18 P F003

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.