DSNU1388I csect-name COLGROUP DATA SORT REQUIRED. ESTIMATED SPACE REQUIRED = space-value MB, SPACE SPECIFIED BY THE spacevar PARAMETER = storage-limit-value MB

Explanation

When statistics were collected on a single-column column group, a data sort was performed by a sort program. Not enough memory was available to avoid the sort.

Statistics were collected either by the RUNSTATS utility or inline by another utility.

csect-name

The name of the control section that issued the message.

space-value

The estimated storage, in MB, that is needed for the column group sort. This value exceeds storage-limit-value.

space-value is a Db2 estimate that might be higher than the amount of space that is actually needed for the sort. The higher the number of distinct values in a single-column column group, the more space that is needed for the sort. If RUNSTATS has never been executed on this column, no statistics exist to help Db2 determine the number of distinct values in the column that need to be sorted. Without those statistics, Db2 assumes a default amount of storage, which might be more than required for low-cardinality columns. Subsequent RUNSTATS jobs benefit from the existence of prior statistics.

spacevar

The source of storage-limit-value that Db2 used for this utility job:

ZPARM

The STATCLGSRT subsystem parameter

KEYWORD

The STATCLGMEMSRT option in the utility statement

storage-limit-value

The amount of memory, in MB, that the utility can use for sorting records for the column group. This value is specified by spacevar.