DSNU3357I csect-name - MAXIMUM SORT AMOUNT ESTIMATION VARIATION WAS maximum-variation PERCENT
Explanation
This message reports information about the maximum variation between estimated and actual sort amounts, based on the number and length of sort records, for all utility sort work.
- maximum-variation
- The maximum variation percentage between estimated and actual sort amounts for all utility sort work.
A large variation between actual values and estimated values might indicate a problem 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)