1

Is there a way to access statistics about IO operations per second in DB2 9.7? I am not interested in the buffer pool hit ratio, just IOPS.

Storage managers reported us that a few days ago average IOPS is over 5000 (previously it was 300 they said). I just want to track those numbers which storage managers reported us because I do not want to this problem re-occur.

Paul White
  • 94,921
  • 30
  • 437
  • 687
Dejan
  • 695
  • 7
  • 20
  • 34

1 Answers1

1

This is a matter of looking at physical writes per buffer pool or tablespace over time. db2top will tell you this if you are in Delta mode and look at the "Delta p_reads/s" column.

Ian Bjorhovde
  • 2,125
  • 11
  • 10