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