Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2012
    Posts
    134

    Unanswered: monitor index usage

    Hi all,
    I'm using DB2 10.5 on Linux.
    I have a number of indexes which I should check that are used properly, in particular I want to check:
    - number of times they're updated
    - number of index seeks
    - number of index scans
    - number of table scans on related table

    Could you please suggest how can I achieve this?
    Thanks

  2. #2
    Join Date
    Jul 2017
    Posts
    1

    please try the following to provide some info your index uage


  3. #3
    Join Date
    Jul 2017
    Location
    Near Philly
    Posts
    3
    Any idea how to get a moderator to help me so I can post?
    I am new to site and have posted but none appear!

  4. #4
    Join Date
    Mar 2012
    Posts
    134
    Thanks Scott for your reply.
    In the link you posted I see a method to check index_seeks and index scans but I don't see a way to check for the number of times the index is updated.
    Any idea of how to get this info?

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,540
    Provided Answers: 11
    register to the forum - logon and you can create new entries
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5-V11 Fundamentals- DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Mar 2012
    Posts
    134
    I also found this link where the index usage is monitored through usage list while the link from Scott suggests MON_GET_INDEX:
    https://www.ibm.com/developerworks/d...sis/index.html

    A weird but interesting thing that I discovered is that for an index I have a completely different result if I monitor it via usage list or via MON_GET_INDEX.
    In particular, I find that the index is used 0 times according MON_GET_INDEX but many times according to MON_GET_INDEX_USAGE_LIST.

    Which of the 2 is correct?

  7. #7
    Join Date
    Jul 2017
    Location
    Near Philly
    Posts
    3
    Quote Originally Posted by przytula_guy View Post
    register to the forum - logon and you can create new entries
    I did register and log on. Nothing appears though.

  8. #8
    Join Date
    Mar 2012
    Posts
    134
    Is anyone aware of the difference between MON_GET_INDEX and MON_GET_INDEX_USAGE_LIST and which of the 2 I can trust?

Posting Permissions

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