As discussed in system performance, monitor disk activity, CPU and memory usage to determine whether the disk subsystems, processing speed or paging are limiting performance.
Use the database systemmonitor to help you tune this configuration parameter using information from the snapshot data (or event monitor) about write activity from a buffer pool.
In IBM DB2 9.7, both the activity and statistics event monitors have a DETAILS_XML monitor element that stores an XML document which contains a wealth of activity and system metrics.
在IBM DB 2 9.7中,活动和统计事件监控器都具有DETAILS_XML监控器元素,该元素存储包含大量活动和系统指标的XML文档。