DB2 Tips n Tricks – Part 5 – Table Level Monitoring by MON_GET_TABLE() Function

Demonstrate Table Level Monitoring using 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 Bufferpool Tuning
Lock Wait Time / Number of Lock Waits – Calculate Average Time an Application waits for acquiring a lock on a table.
and Much More……Demonstrated with Examples.

Happy Learning and Enjoy!!!!
Thanks,
DB2-LUW-ACADEMY