| Computers Forum Index » Computer - Databases - Informix » Number of pid in output from onstat -g ses... |
|
Page 1 of 1 |
|
| Author |
Message |
| Peternt... |
 Posted: Wed Oct 07, 2009 3:42 pm |
|
|
|
Guest
|
Please, if anybody knows about this question:
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
Thanks in advance |
|
|
| Back to top |
|
|
|
| Frank Langelage... |
| Posted: Wed Oct 07, 2009 9:39 pm |
|
|
|
Guest
|
Peternt wrote:
Quote: Please, if anybody knows about this question:
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
Thanks in advance
This is the situation if you have Java programs connecting to the
database using JDBC.
The program is running on computer srv005 ans is connecting as user
netcli to the server.
That's all what is available, probably because the JDBC driver does not
provide more information and more is not mandatory. |
|
|
| Back to top |
|
|
|
| Jonathan Leffler... |
| Posted: Wed Oct 07, 2009 11:09 pm |
|
|
|
Guest
|
Peternt wrote:
Quote: 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.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler at (no spam) earthlink.net, jleffler at (no spam) us.ibm.com
Guardian of DBD::Informix v2008.0229 -- http://dbi.perl.org/
publictimestamp.org/ptb/PTB-7326 whirlpool0 2009-10-07 18:00:05
B54990E9A312246754214320478AD43D983C1D1A056C3332F53D8D235DC13BF3F949EF
370EB2EDEF93C9C3700B6C7875E973CE1CD91F0391E3ACEB079BD6382 |
|
|
| Back to top |
|
|
|
| Fernando Nunes... |
| Posted: Thu Oct 08, 2009 2:05 am |
|
|
|
Guest
|
Jonathan Leffler wrote:
Quote: Peternt wrote:
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.
I'm sorry Jonathan, but that is not correct.
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. |
|
|
| Back to top |
|
|
|
|
