performance related queries to know

prasanth.m · #1 (**permalink**) 01-28-12, 05:30

Hello every one...

I hope u people are all doing well.......

I just want to know a "query" in db2 which will give the information of a perticular table which was viewed/used more times than the remaining tables in the database.... that's all......

In Advance ..... Thanks for ur response....

have a great Presence....>

n_i · #2 (**permalink**) 01-28-12, 11:16

MON_GET_TABLE table function - get table metrics - IBM DB2 9.7 for Linux, UNIX, and Windows

prasanth.m · #3 (**permalink**) 01-30-12, 06:42

Very happy for ur answer.....and response

and thanks again.....

prasanth.m · #4 (**permalink**) 02-19-12, 16:21

well thanks for the answer....
i hav got what i want actually...

but i dont know how to EXECUTE Privileges on MON_GET_TABLE Function...

Can any one please help me with this...

bcz i tried but i couldn't able to make it.....

i have used db2pd -db dbname -tcbstats .... to get statistics of a perticular table but it jst gives info about a perticular table.....

So.... I will be waiting for ur response...

AnyWay ... Thanks again for ur interest .....

Internet Services

Web Development

Digital Marketing

Consumer Tech