DSNU3350I csect-name - SORT task-prefix: number-sorted RECORDS SORTED, ESTIMATED number-estimated, VARIATION variation-percent PERCENT
Explanation
This message reports information about the actual and estimated numbers of records processed for each utility sort task.
- task-prefix
- The prefix of the sort work data set used by the utility sort task.
- number-sorted
- The number of records processed.
- number-estimated
- The estimated number of records processed.
- variation-percent
- The percentage of variation between the actual and estimated number of sort records processed.
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 not controlled by Db2. If the collected statistics in the Db2 catalog are out-of-date, collect statistics again soon.
Severity
0 (informational)