Re: Number of pid in output from onstat -g ses

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. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@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

Jonathan Leffler wrote: > 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.