Unanswered: How to monitor and track the db2 resource usage
I need to Monitor and track db resource utilization only on a specif interval and extract the data to a report
I want to extract a report which contains
a) object (table/row) being locked
b) How long each given lock was held
c) And other connections blocking on it
2) Rows changed/queried
With every release we migrate db changes to PROD. at the time when this process taking place i want to enable the method im using to capture above mention data, and after the process i want to disable the method again.
Can you guide me a way of doing this..??
Links, suggestions would be help massively