PH40942: AFTER APAR PH35218, POTENTIAL HANGING SITUATION 21/10/07 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only)
  After the fix for APAR PH35218 has been applied, Db2 HPU can
  hang if the unload statement specifies a set of at least two
  SELECT statements that satisfy the following conditions:
     - they involve the same table
     - they are processed in native mode
     - they specify ORDER BY clauses that request the same order
     - they specify a common output dataset for the unloaded data
  (OUTDDN option)
     - at least one SELECT statement specify a WHERE clause
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: After the fix for APAR PH35218 has been *
  *                      applied, Db2 HPU can hang when the      *
  *                      following conditions are fulfilled :    *
  *                      - an unload statement specifies a set   *
  *                      of at least two SELECT statements that  *
  *                      satisfy the following conditions:       *
  *                         - they involve the same table        *
  *                         - they are processed in native mode  *
  *                         - they specify ORDER BY clauses that *
  *                           request the same order             *
  *                         - they specify a common output       *
  *                           dataset for the unloaded data      *
  *                           (OUTDDN option)                    *
  *                         - at least one SELECT statement      *
  *                           specify a WHERE clause             *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After APAR PH35218, potential hanging situation
  

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

• INZCHECK INZCRX10 INZCRXSM INZCRXSQ INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI78016

     UP21/11/20 P F111 {

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.