Calculating sort pool size

The Db2 sort process uses two kinds of storage: local storage and buffer pool storage. Sort pool storage and buffer pools have storage above the 2 GB bar.

Calculating sort pool storage in local storage
The sort process creates fixed-length storage pools in local storage for internal sort structures and work areas. Local storage is created above the 2 GB bar at allocation time.
Adjusting buffer pool storage that is used for sort work files
Sort processing uses pages in the Db2 buffer pool for its initial input, for work files that contain intermediate results, and for the final output.

Parent topic: Virtual storage requirements for storage pools and working storage

Related reference

MAX DATA CACHING field (MXDTCACH subsystem parameter)