PM82949: DB2 SORT PERFORMANCE IMPROVEMENT - ELAPSED TIME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Elapsed time is reduced by changing the algorithm to employ
  memory objects in cases when they were previously disabled due
  to certain system storage values.
  
  The use of memory objects typically reduces elapsed time
  because DASD does not need to be used for intermediate SORTWORK
  files.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Sort.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Elapsed time is reduced  by enhancing   *
  *                      the algorithm to employ memory objects  *
  *                      in cases when they were previously      *
  *                      disabled due to certain system storage  *
  *                      values.                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK92265

Modules/Macros

•    CNKCEOS  CNKD1EOS CNKD3MAI
  

Fix information

• Fixed component name

  DB2 SORT FOR Z/

• Fixed component ID

  5655W4200

Applicable component levels

• R130 PSY UK92265

     UP13/03/14 P F303

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.