Today, we will focus on the actual operation process of the adaptive utility of DB2 9 Distributed Management, and automatic maintenance activities (backup, statistical data collection, statistical data analysis, and table/index reorganization) system resources are consumed during running, which affects database performance.
In addition, offline database backup and table/index reorganization restrict access to tables, indexes, or the entire database. To minimize the impact on the system, you can use the DB2 adaptive utility throttling system to adjust the resource usage for certain automatic maintenance activities.
The adaptive utility throttling system was introduced in DB2 8.1.2. This system enables maintenance utilities to run during a period of high workload while limiting their impact on the system to an acceptable range. This throttling system also enables the utility to automatically obtain more computing resources during off-peak hours, while reducing resource usage during peak hours. In DB2 9.5, the following maintenance operations can take advantage of the adaptive utility throttling system:
Statistical data collection
Backup operation
Data rescheduling
Asynchronous index cleanup
You may have used the utility for throttling, but are not aware of it. By default, DB2 automatically throws some maintenance utilities that are automatically called, such as automatic RUNSTATS. The above content is an introduction to the adaptive utility of Distributed Management of DB2 9 for throttling.
The above content is an introduction to the adaptive utility of Distributed Management of DB2 9 for throttling.