Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    3

    Question Unanswered: performance related queries to know

    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....>

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

  3. #3
    Join Date
    Jan 2012
    Posts
    3
    Very happy for ur answer.....and response

    and thanks again.....

  4. #4
    Join Date
    Jan 2012
    Posts
    3

    Question Want to Know

    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 .....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •