Re: Number of pid in output from onstat -g ses
- From: Fernando Nunes <domusonline@xxxxxxxxx>
- Date: Wed, 07 Oct 2009 23:05:47 +0100
Jonathan Leffler wrote:
Peternt wrote:I'm sorry Jonathan, but that is not correct.What do it mean pid = -1 in output from onstat -g ses ?
I have an excess of connections from a server, but we can not
determine the origin (the application that opens the connections)
Furthermore, the tty column shows "-", for example:
session #RSAM total used
id user tty pid hostname threads memory
memory
4789782 netcli - -1 srv005 1 212992 65192
If the client is not local (on the same machine as IDS), the PID is -1.
If the client is local, then the PID tells the client process ID.
the PID is always the client PID independently if it's local or not.
-1 as the other reply explains, means that it's a java application connecting through JDBC. Unfortunately it's not possible in Java to find the current PID (without calling native interface calls). So the JDBC clients can't collect the PID... This is a real annoyance for anybody that needs to dig into JDBC connection problems... It's usual for me to have the need to inform someone that their application is causing problems, and usually they ask me "which process? Which application" and in these situation (JDBC) I can only tell the client hostname... It could help if we were able to tell the client tcp port for example (did I see plans for this?). That could be used to find the attached process.
Regards.
.
- References:
- Number of pid in output from onstat -g ses
- From: Peternt
- Re: Number of pid in output from onstat -g ses
- From: Jonathan Leffler
- Number of pid in output from onstat -g ses
- Prev by Date: Re: Number of pid in output from onstat -g ses
- Next by Date: Re: Informix-list Digest, Vol 191, Issue 3
- Previous by thread: Re: Number of pid in output from onstat -g ses
- Next by thread: RE: Informix-list Digest, Vol 191, Issue 3
- Index(es):
Relevant Pages
|
Loading
