Db2 Query Monitor performance recommendations
This exception enables Db2 Automation Expert and Db2 Query Monitor to work together to provide smarter reorganization recommendations. Using these products together helps your organization avoid unnecessary reorganizations, thereby reducing CPU cycles, memory use, disk space usage, and the impact on your applications.
The following table explains the exception value (under the Query Monitor performance recommendations heading) for Db2 Query Monitor that appears on the Update Exceptions Profile Display. See the topic Smarter reorganization recommendations with Db2 Automation Expert and Db2 Query Monitor for details about using this feature.
Note: In addition to the REORG_OVERRIDE exception, you must select at least one other exception to trigger smarter reorganization recommendations. It is recommended that you choose an exception that evaluates whether the objects in the job profile require reorganization (such as the real-time statistic exception DAYS_SINCE_LAST). Date and time-related exceptions (Day of Week, Day of Month, and Time of Day) are not valid with REORG_OVERRIDE.
| Exception | Description |
|---|---|
| REORG_OVERRIDE | Triggers an exception to call the Db2 Query Monitor reorganization recommendation function during the job build. |