I am using DB2 9.7 and used below sql to get the info.
Could any body please confirm if this si correct.
Code:
select
to_char(current timestamp,'HH:MI:SS') as time,
sum(DIRECT_READ_REQS) as DIRECT_READ_REQS,
sum(DIRECT_WRITE_REQS) as DIRECT_WRITE_REQS,
sum(pool_data_l_reads + pool_temp_data_l_reads + pool_index_l_reads + pool_temp_index_l_reads + pool_xda_l_reads + pool_temp_xda_l_reads) as logical_reads,
sum(pool_data_p_reads + pool_temp_data_p_reads + pool_index_p_reads + pool_temp_index_p_reads + pool_xda_p_reads + pool_temp_xda_p_reads) as physical_reads,
sum((pool_data_writes + pool_index_writes + pool_xda_writes)) as TOTAL_WRITES
from table(SYSPROC.MON_GET_BUFFERPOOL('',-1));