PH36330: INCORRECT NUMBER OF ESTIMATED RECORDS TO SORT IF MULTI SELECT WITH ORDER CLAUSE AGAINST SAME PARTITIONED OBJECT INTO NOT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The estimated number of records to be sorted is incorrect wich
  can lead to failures in the sort process.
  This occurs when a single UNLOAD statement fulfills all the
  following conditions:
   - GBLPARAL YES applies
   - it specifies at least two logical unloads (SELECT statements)
  with distinct output datasets and that satify all the following
  conditions: :
     - they involve the same partitioned tablespace
     - they are run in native mode
     - they request thhe date be unload into global datasets
     - they specify an ORDER clause
  The incorrect estimated number of rows affects only the first
  unload involved in the issue that Db2 HPU processes.
  

Local fix

•  if applicable, consider either of the following changes:
   - add the GBLPARAL NO option
   - run the unload in SQL mode by specifying the DB2 FORCE option
   - split up the Db2 HPU step into as many steps as there are
  SELECT statements involved in the issue.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload         *
  *                 for z/OS                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The estimated number of records to be   *
  *                      sorted is incorrect wich can lead to    *
  *                      failures in the sort process.           *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Overestimated number of estimated records to sort if multi
  SELECT with ORDER clause against same partitioned object into
  not partitioned dataset.
  

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

• INZ$$PRM INZTDSC  INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI75101

     UP21/05/07 P F105

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.