Unanswered: db2 performance issue - large number of IOPS how to determine problem?
DB2 database is on storage. we are using 9.7 Storage administrators reported that today database was doing 5000 IOPS (during past days average number was 300 IOPS). Those are disk operations from server to disk system. db2data is currently on 89%. Today we did not do any large upload. How is this possible what happned to cause this problem?
thank you for response.
I am the administrator and few other users but no additional queries were done.
Can I somehow determine the query which caused the problem?
db2top is useful only for current situation.
I am interested in the past.
Can I see it somehow? I know I can turn the snapshot on but that is also for future use.
Is there some other easiest way to find long running queries?