Buffer utilization ratio

Indicates the ratio of the number of pages requested to the number read; values less than 2 indicate a problem with the buffer size or with the design of the database

• Increase the number of buffer pages
• Reassign files to buffers

Forced writes

Indicates the number of times CA IDMS/DB had to write a buffer page to storage in order to read a database page

• Increase the number of buffer pages
• Reassign files to buffers
• Issue COMMITs more frequently in update jobs

Buffer waits

Indicates the number of times the buffer was requested but was not available

• Increase the number of buffer pages
• Reassign files to buffers