session versus VP
Hello, On Informix 10.00 FC6 I have a cpu VP among 3 which is overloaded. I would like to know which session(s) are using the cpu in this VP. Any tricks ? Many thanks for your advices. Bernard Caillet
Try this:
onstat -g glo lists the VP's.
onstat -g cpu lists the session (thread) id and the VP it is associated with.
Also,
onstat -g ses lists the session id and the pid, then
ps -u followed by the instance owner name, will list all the pid's for that
instance.
You should be able to tie session to VP to pid to program to user ...
If you use onstat -g act this will print all running threads.
John F. Miller III
STSM, Support Architect
miller3@us.ibm.com
503-578-5645
IBM Informix Dynamic Server (IDS)
ids-bounces@iiug.org wrote on 10/07/2009 06:52:07 AM:
> [image removed]
>
> session versus VP [17405]
>
> BERNARD CAILLET
>
> to:
>
> ids
>
> 10/07/2009 06:53 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> Hello,
>
> On Informix 10.00 FC6 I have a cpu VP among 3 which is overloaded.
>
> I would like to know which session(s) are using the cpu in this VP.
>
> Any tricks ?
>
> Many thanks for your advices.
>
> Bernard Caillet
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>