PH39836: ABENDS0CX OR INCORRECT UNLOADED DATA 21/08/19 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only) After APAR PH35218 has been applied,
  Db2 HPU terminates with an ABENDS0Cx or unloads incorrect data
  (incorrout) when all the following conditions are fulfilled :
  - an unload statement specifies a set of more than one SELECT
  statement against the same table that satisfy the following
  conditions:
     - all the SELECT statements are processed in native mode
     - none of the SELECT statements specify a WHERE clause
     - at least one SELECT statement specifies an ORDER BY clause
     - the first SELECT statement does not specify any ORDER
  clause (either ORDER BY or ORDER CLUSTER)
  

Local fix

• if applicable, rewrite the unload statement  to reorganize the
  set of involved SELECT statements so that the first of them has
  an ORDER BY clause or make sure the SELECT statements causing
  the issue are run 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 enhancement PH35218 has been  *
  *                      applied, Db2 HPU terminates with an     *
  *                      ABENDS0Cx or unloads incorrect data     *
  *                      (incorrout) when all the following      *
  *                      conditions are fulfilled :              *
  *                      - an unload statement specifies a set   *
  *                      of more than one SELECT statement       *
  *                      against the same table that satisfy the *
  *                      following conditions:                   *
  *                         - all the SELECT statements are      *
  *                           processed in native mode           *
  *                         - none of the SELECT statements      *
  *                           specify a WHERE clause             *
  *                         - at least one SELECT statement      *
  *                           specifies an ORDER BY clause       *
  *                         - the first SELECT statement does    *
  *                           not specify any ORDER clause       *
  *                           (either ORDER BY or ORDER CLUSTER) *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  After PH35218, ABENDS0Cx or incorrect unloaded data if multiple
  SELECT against a single table
  

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 UI76902

     UP21/09/03 P F109 {

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.