Search result title:
PM82949: DB2 SORT PERFORMANCE IMPROVEMENT - ELAPSED TIME (Community support)

28 February 2014
Search result summary: Elapsed time is reduced by changing the algorithm to employ memory objects in cases when they were previously disabled due
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PM82949

Search result title:
PH42837: 0C4 ABEND THAT IS SOMETIMES OBSERVED IN THE DB2SORT ALGORITHM EXPLOITING THE SORT ACCELERATOR TECHNOLOGY (Community support)

5 February 2022
Search result summary: 0C4 ABEND that is sometimes observed in the DB2SORT algorithm exploiting the Sort accelerator technology
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PH42837

Search result title:
PK84412: REORG ELAPSE TIME INCREASES DUE TO PROBLEM WITH THE ALGORITHM IN THE PARALLEL SORT TASK (Community support)

3 August 2009
Search result summary: It seems there is a problem with the algorithm in the parallel sort task of REORG which results in an elongated elapsed time.
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PK84412

Search result title:
Sorting of character data in OpenPages is different on Oracle and Db2 based systems (Community support)

12 October 2022
Search result summary: The OpenPages application relies on the database to perform sorting of data. The underlying character-based sort mechanics of Oracle and Db2 are different and the same data in Oracle and Db2 might be presented in a different order. The difference in these sort mechanics is fundamental to the underlying database and not a product defect.
Search result URL: Search result URL: https://www.ibm.com/support/pages/node/6602049

Search result title:
PM32705: IMPROVE DB2 SORT FOR Z/OS INVOCATION SEQUENCE (Community support)

2 May 2011
Search result summary: Utilities that invoke multiple sorts in sequence should refresh the used and available resources after each sort or parallel
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PM32705

Search result title:
PM65767: IN V10 NFM, WORKFILE TABLE SPACE SELECTION ALGORITHM IS NOT SELECTING WORKFILE PBG TABLE SPACES IN AN EXPECTED MANNER (Community support)

1 October 2012
Search result summary: In V10 NFM, DB2 allows for creation of partition-by-growth (PBG) table spaces in Workfile database. However, DB2 is not selecting
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PM65767

Search result title:
PH06054: BETTER ESTIMATE OF THE SIZE OF THE INPUT IMAGE COPY AND AMOUNT OF DATA NEEDED TO BE SORTED (Community support)

13 February 2021
Search result summary: When Db2 HPU unloads the data from an image copy which must be sorted (INLINE image copies or image copies created by the
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PH06054

Search result title:
PH51213: THE ALGORITHM TO EXPLOIT IBM'S ZSORT ACCELERATOR MAY NOT BEING UTILIZED WHEN THE DD STATEMENT DB2SORTI IS MISSING. (Community support)

1 February 2023
Search result summary: The algorithm to exploit IBM's zSORT accelerator may not being utilized when the DD statement DB2SORTI is missing.
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PH51213

Search result title:
II14502: DB2 V7/V8/V9 SORT RECOMMENDED MAINTENANCE INFORMATION LAST UPDATED JUNE 29, 2009 (Community support)

29 June 2009
Search result summary: Following is a list of DB2 V7/V8/V9 SORT PTFs for customers that are utilizing SOSRT via RDS SQL Query, Performance, or DB2
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/II14502

Search result title:
IO10709: TDS server may not sort national language characters properly (Community support)

15 February 2024
Search result summary: When requesting sorted results from the TDS server, the sort order depends on the code page and collation options of the
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/IO10709