DSNU3351I csect-name - SORT task-prefix: number-sorted : AVERAGE RECORD LENGTH PROCESSED average-length, ESTIMATED estimated-length,VARIATION variation-percent PERCENT
Explanation
This message reports information about estimated and actual record lengths for each utility sort task.
- task-prefix
- The prefix of the sort work data set used by the utility sort task.
- average-length
- The average length of records that are processed for the sort operation.
- estimated-length
- The estimated average length of records that are processed for the sort operation.
- variation-percent
- The variation between the actual and estimated average record length.
A large variation between actual values and estimated values might indicate problems with real-time statistics or be caused by outdated statistics. If the estimates are too low, utilities might fail. If the estimates are too high, memory and disk storage resources might be allocated unnecessarily, negatively affecting other applications that run at the same time.
The estimates are based on real-time statistics and database object statistics that are collected in the Db2 catalog. If real-time statistics values are missing, Db2 attempts to use real-time statistics for related objects, such as indexes, before it uses statistics in the Db2 catalog.
System action
Processing continues.
User response
If real-time statistics values are incorrect or missing, check for processes that might invalidate or corrupt the collection of real-time statistics, such as point-in-time recovery or updates of objects that are not controlled by Db2. If the collected statistics in the Db2 catalog are out-of-date, collect statistics again soon.
Severity
0 (informational)