How real-time statistics affect sort work data set allocation for Db2 utilities

Db2 uses real-time statistics data to estimate the size of sort work data sets to allocate for certain utilities.

If real-time statistics data is available, Db2 uses real-time statistics to determine data set sizes for dynamically allocated sort work data sets for the following utilities:

• CHECK INDEX
• REBUILD INDEX
• REORG TABLESPACE
• RUNSTATS with the COLGROUP keyword