As a DBA, your efforts is to make sure that you have as much asynchronous read activity on your database. The intentions are good but how do I know the amount of asynchronous activity going one in my database.
This SQL will give you the Asynchronous read ratio (ARR) and like buffer pool hit ratio, you will like to monitor this to see the amount of asynchronous read activity going on your system. The more the ARR, better it is for you.
SELECT BP_NAME, (total_async_reads * 100 /total_physical_reads) ARR FROM SYSIBMADM.BP_READ_IO WHERE BP_NAME NOT LIKE 'IBMSYSTEM%';