PH47219: AFTER PH29757, POTENTIAL HANGING SITUATON AT THE END OF AN UNLOAD INVOLVING INDEXSCAN OR XML/LOB DATA

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After the application of the fix for PH29757, an unload run in
  native mode might enter an infinite loop at the end of a single
  unload.
  This could occur if one of the following condition is fulfilled:
  - condition 1)  an ORDER clause is processed using the index
  scan feature
  - condition 2) XML or LOB data must be unloaded
  

Local fix

• if condition 1 applies, consider disabling the indexscan feature
  by specifying INDEXSCAN NO.
  if either of condition 1 or 2 applies, 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 application of the fix for    *
  *                      PH29757, an unload run in native mode   *
  *                      might enter an infinite loop at the end *
  *                      of a single unload.                     *
  *                                                              *
  *                      This could occur if one of the          *
  *                      following condition is fulfilled:       *
  *                      - condition 1) an ORDER clause is       *
  *                      processed using the index scan feature  *
  *                      - condition 2) XML or LOB data must be  *
  *                      unloaded                                *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After PH29757, potential hanging situation at the end of an
  unload involving indexscan or  XML/LOB data
  

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

• INZHPUCL INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI81223

     UP22/07/07 P F207 {

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.