Jan 21, 2015
DB2 Tips n Tricks Part 5 - Table Level Monitoring by MON_GET_TABLE() Function
Monitoring Table Activities : Tables with most Number of Rows Read,Inserted,Updated,Deleted Categorize Read or Write Intensive Tables Number of Table scans indicating Need for Indexes Number of Rows Read per Table Scan Hit Ratio - Physical Reads / Logical Reads at a Table level useful for Buffer pool Tuning Lock Wait Time / Number of Lock Waits - Calculate Average Time an Application waits for acquiring a lock on a table.
