Write intents

The number of set write intents is held in the QBACSWS field of the DB2 accounting record.

The number of set write intents is not related to the actual number of write I/Os from the buffer pools, instead it represents the number of times a page has been marked for update. Even in a read-only transaction this number can be present, because the intended writes to the temporary work files used in a DB2 sort are also counted.

The typical case is that the number of set write intents is much higher than the number of write I/Os. The ratio between these two numbers depends on the size of the buffer pool and the workload. It is not a good measurement for write I/O activity, but does indicate the complexity of the transactions.



dfhtk52.html | Timestamp icon Last updated: Sunday, 4 June 2017