onstat -g ses - getting the pid

I am running 11.50.FC7 on Solaris 10 Sparc. I have a couple of tables that are locked. I am trying to see what is locking them. I ran onstat -g sql to determine some ids that were associated with the tables. I then ran onstat -g ses to get the pid of the session. For these particular sessions I am seeing a pid of -1. What does that mean? Larry

Usually means a JDBC connection (or at least that is what it means to me when I see them in my environment). Andrew -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Wednesday, December 09, 2015 1:58 PM To: ids@iiug.org Subject: onstat -g ses - getting the pid [36197] I am running 11.50.FC7 on Solaris 10 Sparc. I have a couple of tables that are locked. I am trying to see what is locking them. I ran onstat -g sql to determine some ids that were associated with the tables. I then ran onstat -g ses to get the pid of the session. For these particular sessions I am seeing a pid of -1. What does that mean? Larry **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

A pid of -1 means that the session is probably a Java application ir Java based app server which do not report a pid. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Dec 9, 2015 at 2:58 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > I am running 11.50.FC7 on Solaris 10 Sparc. > > I have a couple of tables that are locked. I am trying to see what is > locking > them. > > I ran onstat -g sql to determine some ids that were associated with the > tables. > > I then ran onstat -g ses to get the pid of the session. For these > particular > sessions I am seeing a pid of -1. What does that mean? > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113fe84ea9510205267d01f0

So, is there a way to figure out precisely what is running it then if we have multiple Java connections? It would be nice to be able to associate it to a particular connection or application? It seems like, with no pid, it could be one of many. Larry > To: ids@iiug.org > From: andrew@informix-dba.com > Subject: RE: onstat -g ses - getting the pid [36198] > Date: Wed, 9 Dec 2015 15:27:22 -0500 > > Usually means a JDBC connection (or at least that is what it means to me > when I see them in my environment). > > Andrew > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY > SORENSEN > Sent: Wednesday, December 09, 2015 1:58 PM > To: ids@iiug.org > Subject: onstat -g ses - getting the pid [36197] > > I am running 11.50.FC7 on Solaris 10 Sparc. > > I have a couple of tables that are locked. I am trying to see what is > locking them. > > I ran onstat -g sql to determine some ids that were associated with the > tables. > > I then ran onstat -g ses to get the pid of the session. For these particular > sessions I am seeing a pid of -1. What does that mean? > > Larry > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Nope, none. The only thing you can do is to have your Java sessions report the session id they are using, but in some environments, with non-persistent connection pools configured, that can change from query to query. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Dec 9, 2015 at 3:34 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > So, is there a way to figure out precisely what is running it then if we > have > multiple Java connections? It would be nice to be able to associate it to a > particular connection or application? It seems like, with no pid, it could > be > one of many. > > Larry > > > To: ids@iiug.org > > From: andrew@informix-dba.com > > Subject: RE: onstat -g ses - getting the pid [36198] > > Date: Wed, 9 Dec 2015 15:27:22 -0500 > > > > Usually means a JDBC connection (or at least that is what it means to me > > when I see them in my environment). > > > > Andrew > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > > SORENSEN > > Sent: Wednesday, December 09, 2015 1:58 PM > > To: ids@iiug.org > > Subject: onstat -g ses - getting the pid [36197] > > > > I am running 11.50.FC7 on Solaris 10 Sparc. > > > > I have a couple of tables that are locked. I am trying to see what is > > locking them. > > > > I ran onstat -g sql to determine some ids that were associated with the > > tables. > > > > I then ran onstat -g ses to get the pid of the session. For these > particular > > sessions I am seeing a pid of -1. What does that mean? > > > > Larry > > > > > **************************************************************************** > > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113fe84ecdb9c205267d194f

Thank you all for the input. Larry > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: onstat -g ses - getting the pid [36201] > Date: Wed, 9 Dec 2015 15:40:40 -0500 > > Nope, none. The only thing you can do is to have your Java sessions report > the session id they are using, but in some environments, with > non-persistent connection pools configured, that can change from query to > query. > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Wed, Dec 9, 2015 at 3:34 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > So, is there a way to figure out precisely what is running it then if we > > have > > multiple Java connections? It would be nice to be able to associate it to a > > particular connection or application? It seems like, with no pid, it could > > be > > one of many. > > > > Larry > > > > > To: ids@iiug.org > > > From: andrew@informix-dba.com > > > Subject: RE: onstat -g ses - getting the pid [36198] > > > Date: Wed, 9 Dec 2015 15:27:22 -0500 > > > > > > Usually means a JDBC connection (or at least that is what it means to me > > > when I see them in my environment). > > > > > > Andrew > > > > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > LARRY > > > SORENSEN > > > Sent: Wednesday, December 09, 2015 1:58 PM > > > To: ids@iiug.org > > > Subject: onstat -g ses - getting the pid [36197] > > > > > > I am running 11.50.FC7 on Solaris 10 Sparc. > > > > > > I have a couple of tables that are locked. I am trying to see what is > > > locking them. > > > > > > I ran onstat -g sql to determine some ids that were associated with the > > > tables. > > > > > > I then ran onstat -g ses to get the pid of the session. For these > > particular > > > sessions I am seeing a pid of -1. What does that mean? > > > > > > Larry > > > > > > > > **************************************************************************** > > > *** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --001a113fe84ecdb9c205267d194f > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

I would suggest setting DBTEMP to something from within your app which can then be parsed on the server. I put "/tmp:<APPNAME>" - The only reason I put /tmp up front so as not to break ACE, but otherwise DBTEMP appears to be mostly unused these days. Then parse DBTEMP and there is your appname or whatever else you want to see ... John -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of LARRY SORENSEN Sent: Wednesday, December 09, 2015 3:34 PM To: ids@iiug.org Subject: RE: onstat -g ses - getting the pid [36200] So, is there a way to figure out precisely what is running it then if we have multiple Java connections? It would be nice to be able to associate it to a particular connection or application? It seems like, with no pid, it could be one of many. Larry > To: ids@iiug.org > From: andrew@informix-dba.com > Subject: RE: onstat -g ses - getting the pid [36198] > Date: Wed, 9 Dec 2015 15:27:22 -0500 > > Usually means a JDBC connection (or at least that is what it means to > me when I see them in my environment). > > Andrew > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY SORENSEN > Sent: Wednesday, December 09, 2015 1:58 PM > To: ids@iiug.org > Subject: onstat -g ses - getting the pid [36197] > > I am running 11.50.FC7 on Solaris 10 Sparc. > > I have a couple of tables that are locked. I am trying to see what is > locking them. > > I ran onstat -g sql to determine some ids that were associated with > the tables. > > I then ran onstat -g ses to get the pid of the session. For these > particular sessions I am seeing a pid of -1. What does that mean? > > Larry > > ********************************************************************** > ****** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > **************************************************************************** *** > Forum Note: Use "Reply" to post a response in the discussion forum. > **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. -- *CONFIDENTIALITY NOTICE*: This email communication may contain private, confidential, or legally privileged information intended for the sole use of the designated and/or duly authorized recipient(s). If you are not the intended recipient or have received this email in error, please notify the sender immediately by email and permanently delete all copies of this email including all attachments without reading them. If you are the intended recipient, secure the contents in a manner that conforms to all applicable state and/or federal requirements related to privacy and confidentiality of such information.

Ooh, sneaky, I like it! Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Dec 9, 2015 at 4:10 PM, John Fahey <jfahey@mandm.net> wrote: > I would suggest setting DBTEMP to something from within your app which can > then be parsed on the server. > I put "/tmp:<APPNAME>" - The only reason I put /tmp up front so as not to > break ACE, but otherwise DBTEMP appears > to be mostly unused these days. Then parse DBTEMP and there is your appname > or whatever else you want to see ... > > John > > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > LARRY > SORENSEN > Sent: Wednesday, December 09, 2015 3:34 PM > To: ids@iiug.org > Subject: RE: onstat -g ses - getting the pid [36200] > > So, is there a way to figure out precisely what is running it then if we > have multiple Java connections? It would be nice to be able to associate it > to a particular connection or application? It seems like, with no pid, it > could be one of many. > > Larry > > > To: ids@iiug.org > > From: andrew@informix-dba.com > > Subject: RE: onstat -g ses - getting the pid [36198] > > Date: Wed, 9 Dec 2015 15:27:22 -0500 > > > > Usually means a JDBC connection (or at least that is what it means to > > me when I see them in my environment). > > > > Andrew > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > LARRY SORENSEN > > Sent: Wednesday, December 09, 2015 1:58 PM > > To: ids@iiug.org > > Subject: onstat -g ses - getting the pid [36197] > > > > I am running 11.50.FC7 on Solaris 10 Sparc. > > > > I have a couple of tables that are locked. I am trying to see what is > > locking them. > > > > I ran onstat -g sql to determine some ids that were associated with > > the tables. > > > > I then ran onstat -g ses to get the pid of the session. For these > > particular sessions I am seeing a pid of -1. What does that mean? > > > > Larry > > > > ********************************************************************** > > ****** > > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > **************************************************************************** > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- > > *CONFIDENTIALITY NOTICE*: This email communication may contain private, > confidential, or legally privileged information intended for the sole use > of the designated and/or duly authorized recipient(s). If you are not the > intended recipient or have received this email in error, please notify the > sender immediately by email and permanently delete all copies of this email > including all attachments without reading them. If you are the intended > recipient, secure the contents in a manner that conforms to all applicable > state and/or federal requirements related to privacy and confidentiality of > such information. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7bd75710d97abd05267e69bb

Me too.. and I believe John mentioned this before. But I have a couple of questions: - When you say you change DBTEMP from the application... can you elaborate on that? OnUnix/Linux it's trivial to set the URL with "DBEMP=/tmp:$$" but that will give you the PPID of the session. Not a problem if you run a script that runs "java ....". But if the sessions are launched from some sort of daemon.... I suppose we're get to the start - Another option and that's probably what you do, you don't use a PID but some other sort of identifier? This is really annoying, but just for further clarification it's not an Informix issue. Java (at least last time I checked) doesn't offer a method to get the current PID. The only option would be to invoke a native method that would break portability. And this makes query tracking harder, but not only that. In particular it breaks auditing.... as we get a bunch of entries with the pid = -1 (it may vary with the Informix version), that are not related to each other. Of course that would be solved if we could get the SID in the audit logs.... On Wed, Dec 9, 2015 at 10:14 PM, Art Kagel <art.kagel@gmail.com> wrote: > Ooh, sneaky, I like it! > > Art > > Art S. Kagel, President and Principal Consultant > ASK Database Management > www.askdbmgt.com > > Blog: http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on the IIUG, nor any other organization with which I am > associated either explicitly, implicitly, or by inference. Neither do > those opinions reflect those of other individuals affiliated with any > entity with which I am affiliated nor those of the entities themselves. > > On Wed, Dec 9, 2015 at 4:10 PM, John Fahey <jfahey@mandm.net> wrote: > > > I would suggest setting DBTEMP to something from within your app which > can > > then be parsed on the server. > > I put "/tmp:<APPNAME>" - The only reason I put /tmp up front so as not to > > break ACE, but otherwise DBTEMP appears > > to be mostly unused these days. Then parse DBTEMP and there is your > appname > > or whatever else you want to see ... > > > > John > > > > -----Original Message----- > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > LARRY > > SORENSEN > > Sent: Wednesday, December 09, 2015 3:34 PM > > To: ids@iiug.org > > Subject: RE: onstat -g ses - getting the pid [36200] > > > > So, is there a way to figure out precisely what is running it then if we > > have multiple Java connections? It would be nice to be able to associate > it > > to a particular connection or application? It seems like, with no pid, it > > could be one of many. > > > > Larry > > > > > To: ids@iiug.org > > > From: andrew@informix-dba.com > > > Subject: RE: onstat -g ses - getting the pid [36198] > > > Date: Wed, 9 Dec 2015 15:27:22 -0500 > > > > > > Usually means a JDBC connection (or at least that is what it means to > > > me when I see them in my environment). > > > > > > Andrew > > > > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > > LARRY SORENSEN > > > Sent: Wednesday, December 09, 2015 1:58 PM > > > To: ids@iiug.org > > > Subject: onstat -g ses - getting the pid [36197] > > > > > > I am running 11.50.FC7 on Solaris 10 Sparc. > > > > > > I have a couple of tables that are locked. I am trying to see what is > > > locking them. > > > > > > I ran onstat -g sql to determine some ids that were associated with > > > the tables. > > > > > > I then ran onstat -g ses to get the pid of the session. For these > > > particular sessions I am seeing a pid of -1. What does that mean? > > > > > > Larry > > > > > > ********************************************************************** > > > ****** > > > *** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > **************************************************************************** > > *** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > **************************************************************************** > > *** > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > -- > > > > *CONFIDENTIALITY NOTICE*: This email communication may contain private, > > confidential, or legally privileged information intended for the sole use > > of the designated and/or duly authorized recipient(s). If you are not the > > intended recipient or have received this email in error, please notify > the > > sender immediately by email and permanently delete all copies of this > email > > including all attachments without reading them. If you are the intended > > recipient, secure the contents in a manner that conforms to all > applicable > > state and/or federal requirements related to privacy and confidentiality > of > > such information. > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > --047d7bd75710d97abd05267e69bb > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a113f288c1a269205267f5a48

Fernando: John's suggestion was to set DBTEMP to a string that would identify the name of the Java app not the PID of the JRE instance. I would add maybe add some key or option that would further narrow the spec down like the name of the user calling the routine if it is an app server routine. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Dec 9, 2015 at 6:21 PM, Fernando Nunes <domusonline@gmail.com> wrote: > Me too.. and I believe John mentioned this before. > But I have a couple of questions: > > - When you say you change DBTEMP from the application... can you elaborate > on that? OnUnix/Linux it's trivial to set the URL with "DBEMP=/tmp:$$" but > that will give you the PPID of the session. Not a problem if you run a > script that runs "java ....". But if the sessions are launched from some > sort of daemon.... I suppose we're get to the start > - Another option and that's probably what you do, you don't use a PID but > some other sort of identifier? > > This is really annoying, but just for further clarification it's not an > Informix issue. Java (at least last time I checked) doesn't offer a method > to get the current PID. The only option would be to invoke a native method > that would break portability. > And this makes query tracking harder, but not only that. In particular it > breaks auditing.... as we get a bunch of entries with the pid = -1 (it may > vary with the Informix version), that are not related to each other. Of > course that would be solved if we could get the SID in the audit logs.... > > On Wed, Dec 9, 2015 at 10:14 PM, Art Kagel <art.kagel@gmail.com> wrote: > > > Ooh, sneaky, I like it! > > > > Art > > > > Art S. Kagel, President and Principal Consultant > > ASK Database Management > > www.askdbmgt.com > > > > Blog: http://informix-myview.blogspot.com/ > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > > and do not reflect on the IIUG, nor any other organization with which I > am > > associated either explicitly, implicitly, or by inference. Neither do > > those opinions reflect those of other individuals affiliated with any > > entity with which I am affiliated nor those of the entities themselves. > > > > On Wed, Dec 9, 2015 at 4:10 PM, John Fahey <jfahey@mandm.net> wrote: > > > > > I would suggest setting DBTEMP to something from within your app which > > can > > > then be parsed on the server. > > > I put "/tmp:<APPNAME>" - The only reason I put /tmp up front so as not > to > > > break ACE, but otherwise DBTEMP appears > > > to be mostly unused these days. Then parse DBTEMP and there is your > > appname > > > or whatever else you want to see ... > > > > > > John > > > > > > -----Original Message----- > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > > > LARRY > > > SORENSEN > > > Sent: Wednesday, December 09, 2015 3:34 PM > > > To: ids@iiug.org > > > Subject: RE: onstat -g ses - getting the pid [36200] > > > > > > So, is there a way to figure out precisely what is running it then if > we > > > have multiple Java connections? It would be nice to be able to > associate > > it > > > to a particular connection or application? It seems like, with no pid, > it > > > could be one of many. > > > > > > Larry > > > > > > > To: ids@iiug.org > > > > From: andrew@informix-dba.com > > > > Subject: RE: onstat -g ses - getting the pid [36198] > > > > Date: Wed, 9 Dec 2015 15:27:22 -0500 > > > > > > > > Usually means a JDBC connection (or at least that is what it means to > > > > me when I see them in my environment). > > > > > > > > Andrew > > > > > > > > -----Original Message----- > > > > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf > Of > > > > LARRY SORENSEN > > > > Sent: Wednesday, December 09, 2015 1:58 PM > > > > To: ids@iiug.org > > > > Subject: onstat -g ses - getting the pid [36197] > > > > > > > > I am running 11.50.FC7 on Solaris 10 Sparc. > > > > > > > > I have a couple of tables that are locked. I am trying to see what is > > > > locking them. > > > > > > > > I ran onstat -g sql to determine some ids that were associated with > > > > the tables. > > > > > > > > I then ran onstat -g ses to get the pid of the session. For these > > > > particular sessions I am seeing a pid of -1. What does that mean? > > > > > > > > Larry > > > > > > > > > ********************************************************************** > > > > ****** > > > > *** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > > > > > > **************************************************************************** > > > *** > > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > > > > > > > **************************************************************************** > > > *** > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > > > > > > *CONFIDENTIALITY NOTICE*: This email communication may contain private, > > > confidential, or legally privileged information intended for the sole > use > > > of the designated and/or duly authorized recipient(s). If you are not > the > > > intended recipient or have received this email in error, please notify > > the > > > sender immediately by email and permanently delete all copies of this > > email > > > including all attachments without reading them. If you are the intended > > > recipient, secure the contents in a manner that conforms to all > > applicable > > > state and/or federal requirements related to privacy and > confidentiality > > of > > > such information. > > > > > > > > > > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > > > > --047d7bd75710d97abd05267e69bb > > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > -- > Fernando Nunes > Portugal > > http://informix-technology.blogspot.com > My email works... but I don't check it frequently... > > --001a113f288c1a269205267f5a48 > > > > ******************************************************************************* > Forum Note: Use "Reply" to pos