The Index & Data Write Rate graph depicts rates for writing new and changed data and index pages from the buffer pool to the database over consecutive monitoring intervals. These rates are based on the number of pages written per second. The graph contains the following series:
Data —Plots the rate at which data pages are written from the buffer pools to the database.
Index —Plots the rate at which index pages are written from the buffer pools to the database.
D Sync —Plots the rate of synchronous data writes. These types of writes block further execution of the query until they are completed. A high synchronous data write rate can degrade performance.
I Sync —Plots the rate of synchronous index writes. These types of writes block further execution of the query until they are completed. A high synchronous index write rate can degrade performance.
The Statistics tab shows the buffer pool read and write counts used to generate this graph. The names for these statistics begin with either Buffer Pool or I/O. These statistics are derived from the POOL data elements that the DB2 snapshot monitor captures.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
