DB2 Sort overview

IBM® DB2® Sort for z/OS® (also referred to as DB2 Sort) is a DB2 Tool that provides high-speed utility sort processing for data that is stored in DB2 for z/OS databases.

DB2 Sort improves the sort performance of many of the DB2 utilities in the IBM DB2 Utilities Suite and of several other DB2 management tools. The way DB2 Sort improves sort performance is through enhanced sort technology and by communicating with DB2 utilities and tools and then adjusting system resources to ensure optimal sorting. This approach to sorting can result in significantly reduced sort CPU time.

The following DB2 utilities and DB2 Tools can benefit from improved sorting performance by using DB2 Sort:

DB2 utilities:
  • CHECK DATA
  • CHECK INDEX
  • CHECK LOB
  • LOAD
  • REBUILD INDEX
  • REORG TABLESPACE
  • RUNSTATS
Note: DB2 Sort supports all of the utilities in the DB2 Utilities Suite for z/OS V10.1 and V11.1.
DB2 Tools:
  • DB2 Utilities Enhancement Tool for z/OS V2.2 and subsequent releases
  • DB2 Log Analysis Tool for z/OS V3.3 and subsequent releases
  • DB2 Recovery Expert for z/OS V3.1 and subsequent releases
  • DB2 Change Accumulation Tool for z/OS V3.1 and subsequent releases
  • DB2 High Performance Unload for z/OS V4.2 and subsequent releases