DB2 LUW Performance: Progress Review plus Closing Files | IBMDatabaseMagazine.com Blogs

The Synchronous Read Percentage, or SRP, tells us how much random synchronous I/O DB2 is doing. High SRP values are achieved when high quality indexes are in place. When DB2 does too much prefetch I/O scanning (with asynchronous I/O), SRP will be lower. If you have an OLTP database and SRP is less than 80%, absolutely do not upgrade your hardware – you have physical design problems to fix first.

Advertisements