Results 1 to 4 of 4

Thread: Lock Requests

  1. #1
    Join Date
    Jun 2008
    Posts
    16

    Unanswered: Lock Requests

    When I run an onstat -p on Informix 9.21 UC5 on Solaris, I get over 800000000 lockreqs, but when I run the following query against the sysmaster database, I get less than 300000000. Where is onstat -p getting it's information on lockreqs?


    select SUM(lockreqs) from syssesprof;


    Mark

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    the onstat -p is the same from sysmaster:sysprofile.
    This is all acumulative data.

    if you sum the locks from session profile... you are getting how much locks are requested over the ACTIVE sessions.
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Jun 2008
    Posts
    16

    Lock Requests

    Actually, I would like to know how many lock requests there are at any moment in time by the active sessions. If I sum up the lockreqs in syssesprof, that will give me the number of requests made by the current session during their entire session---how would I get a snapshot of the total lock requests being made at a particular moment in time?

    Mark

  4. #4
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    Exactly what you want, is not possible .

    The locks requests over the session profile is a acumulative information.

    You have 2 ways (not a beautiful way, but, maybe work).

    1) execute the "onstat -z" and refresh all statistics information (ALL statistics) and them you get how much locks requests are made over the session. (I strongly not recommend this option because if you need to monitor any other information will be an partial information).

    2) execute the select over the syssesprof each time you want and calculate the difference between each one, them you will get how much locks are requested over this space of time.
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

Posting Permissions

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