Informix

 View Only
Expand all | Collapse all

flags (onstat -g ses)

  • 1.  flags (onstat -g ses)

    Posted Fri December 03, 2021 10:32 AM
    Hello 

    i have some sessions with status "running" and flags "---P---" , not doing or waiting for anything, other sessions are on "---PR--" (reading)

    what does "---P---" mean please ?

    Thanks



    ------------------------------
    John Smith
    ------------------------------


  • 2.  RE: flags (onstat -g ses)

    Posted Fri December 03, 2021 10:46 AM
    Primary thread for the session

    https://www.oninit.com/onstat/pda.php?id=onstat%20-g%20ses

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 3.  RE: flags (onstat -g ses)

    Posted Fri December 03, 2021 11:01 AM
    Yes
    already checked, but i don"t where others flags are "-" !! there s only the 4th position "P" , so i'm wondering what is the session doing !!

    ------------------------------
    John Smith
    ------------------------------



  • 4.  RE: flags (onstat -g ses)

    Posted Fri December 03, 2021 11:17 AM
    What does the stack show, AFAIK it is no 'legal' to have a session without a thread 

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 5.  RE: flags (onstat -g ses)

    IBM Champion
    Posted Fri December 03, 2021 11:37 AM
    I think the question is that is the flags show that there is a primary connection, but the session is not reading, not writing, and not waiting on a condition...then what's it doing?

    I think that you find that the session is sleeping.  If you run onstat -g ses <sid>, and look at the thread, it is likely to show "sleeping" - at least that's what I am seeing.  The dbworker thread seems to be in that state, which makes sense.

    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------



  • 6.  RE: flags (onstat -g ses)

    InnerCircle
    Posted Fri December 03, 2021 12:32 PM
    That's the same set of flags as in 'onstat -u' I'd say.
    For a session having multiple threads (PDQ), the 'P' thread would be the primary (sqlexec) one.

    ------------------------------
    Andreas Legner
    ------------------------------



  • 7.  RE: flags (onstat -g ses)

    IBM Champion
    Posted Fri December 03, 2021 02:13 PM