RE: IDS 8.21 on AIX 5.2 - log of users logging in
Larry asked how to find out which users connected to a database on IDS/XPS 8.21 under AIX 5.2. John Miller suggested sysdbopen()/sysdbclose() stored procedures to log connects and disconnects; Art Kagel countered that the server keeps no connection history and that these procedures only exist in 11.x, though Miller and Jonathan Leffler noted they actually originated in XPS, just possibly after 8.21. Art also pointed out AIX only logs logins if UNIX accounting is enabled. Larry checked his 8.21 docs, found no such procedures, and accepted there was no built-in way — no workaround was offered.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Does anyone remember back to IDS 8.21? By default, is there a way to find out which users logged in and accessed the database over a given period of time? I am running on AIX 5.2. If there is a default log on AIX that keeps track of who logs in, that would work as well. Larry
There is a simple way to accomplish this. You can use sysdbopen() and sysdbclose() to track when user connects and disconnects from each database. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) = From: "LARRY SORENSEN" <lsorensen25@msn.com> = = To: ids@iiug.org = = Date: 01/05/2010 09:40 AM = = Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18538= ] = Sent by: ids-bounces@iiug.org = = Does anyone remember back to IDS 8.21? By default, is there a way to fi= nd out which users logged in and accessed the database over a given period of time? I am running on AIX 5.2. If there is a default log on AIX that keeps trac= k of who logs in, that would work as well. Larry ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
In looking through the documentation, I did a search on sysdbopen for all of the PDF guides I have and nothing showed up. Can you direct me to somewhere that gives examples of how to use these? Larry > To: ids@iiug.org > From: miller3@us.ibm.com > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18539] > Date: Tue, 5 Jan 2010 12:54:33 -0500 > > There is a simple way to accomplish this. You can > use sysdbopen() and sysdbclose() to track when user > connects and disconnects from each database. > > John F. Miller III > STSM, Support Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > = > > From: "LARRY SORENSEN" <lsorensen25@msn.com> = > > = > > To: ids@iiug.org = > > = > > Date: 01/05/2010 09:40 AM = > > = > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18538= > ] > > = > > Sent by: ids-bounces@iiug.org = > > = > > Does anyone remember back to IDS 8.21? By default, is there a way to fi= > nd > out > which users logged in and accessed the database over a given period of > time? I > am running on AIX 5.2. If there is a default log on AIX that keeps trac= > k of > > who logs in, that would work as well. > > 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. >
John Miller iii wrote: > There is a simple way to accomplish this. You can > use sysdbopen() and sysdbclose() to track when user > connects and disconnects from each database. In XPS? -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Yes. 8.2 is XPS. Thanks > To: ids@iiug.org > From: obnoxio@serendipita.com > Subject: Re: IDS 8.21 on AIX 5.2 - log of users logging in [18541] > Date: Tue, 5 Jan 2010 13:01:54 -0500 > > John Miller iii wrote: > > There is a simple way to accomplish this. You can > > use sysdbopen() and sysdbclose() to track when user > > connects and disconnects from each database. > > In XPS? > > -- > Cheers, > Obnoxio The Clown > > http://obotheclown.blogspot.com > I will now proceed to pleasure myself with this fish. > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
IDS doesn't track connection history at all in any version. If you have 11.xx you can install a routine to fire when anyone connects that could make such a record for you, but 8.xx doesn't support that either. AIX will only log login/logout data if you have UNIX accounting turned on. Most production systems no long run UNIX accounting. Art Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Tue, Jan 5, 2010 at 12:39 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > Does anyone remember back to IDS 8.21? By default, is there a way to find > out > which users logged in and accessed the database over a given period of > time? I > am running on AIX 5.2. If there is a default log on AIX that keeps track of > who logs in, that would work as well. > > Larry > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174bed924ba834047c6fff85
sysdbopen/sysdbclose are not supported in 8.xx, that's an 11.xx feature that first appears in 11.10. Art Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Tue, Jan 5, 2010 at 12:59 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > In looking through the documentation, I did a search on sysdbopen for all > of > the PDF guides I have and nothing showed up. Can you direct me to somewhere > that gives examples of how to use these? > > Larry > > > To: ids@iiug.org > > From: miller3@us.ibm.com > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18539] > > Date: Tue, 5 Jan 2010 12:54:33 -0500 > > > > There is a simple way to accomplish this. You can > > use sysdbopen() and sysdbclose() to track when user > > connects and disconnects from each database. > > > > John F. Miller III > > STSM, Support Architect > > miller3@us.ibm.com > > 503-578-5645 > > IBM Informix Dynamic Server (IDS) > > > > = > > > > From: "LARRY SORENSEN" <lsorensen25@msn.com> = > > > > = > > > > To: ids@iiug.org = > > > > = > > > > Date: 01/05/2010 09:40 AM = > > > > = > > > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18538= > > ] > > > > = > > > > Sent by: ids-bounces@iiug.org = > > > > = > > > > Does anyone remember back to IDS 8.21? By default, is there a way to fi= > > nd > > out > > which users logged in and accessed the database over a given period of > > time? I > > am running on AIX 5.2. If there is a default log on AIX that keeps trac= > > k of > > > > who logs in, that would work as well. > > > > 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. > > --001517448aac0e6af4047c701569
Thank you all for your input. Is is as I thought, but I just wanted to make sure. Larry > To: ids@iiug.org > From: art.kagel@gmail.com > Subject: Re: IDS 8.21 on AIX 5.2 - log of users logging in [18546] > Date: Tue, 5 Jan 2010 14:45:43 -0500 > > sysdbopen/sysdbclose are not supported in 8.xx, that's an 11.xx feature that > first appears in 11.10. > > Art > > Art S. Kagel > AdvanceDataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. 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 Tue, Jan 5, 2010 at 12:59 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > In looking through the documentation, I did a search on sysdbopen for all > > of > > the PDF guides I have and nothing showed up. Can you direct me to somewhere > > that gives examples of how to use these? > > > > Larry > > > > > To: ids@iiug.org > > > From: miller3@us.ibm.com > > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18539] > > > Date: Tue, 5 Jan 2010 12:54:33 -0500 > > > > > > There is a simple way to accomplish this. You can > > > use sysdbopen() and sysdbclose() to track when user > > > connects and disconnects from each database. > > > > > > John F. Miller III > > > STSM, Support Architect > > > miller3@us.ibm.com > > > 503-578-5645 > > > IBM Informix Dynamic Server (IDS) > > > > > > = > > > > > > From: "LARRY SORENSEN" <lsorensen25@msn.com> = > > > > > > = > > > > > > To: ids@iiug.org = > > > > > > = > > > > > > Date: 01/05/2010 09:40 AM = > > > > > > = > > > > > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18538= > > > ] > > > > > > = > > > > > > Sent by: ids-bounces@iiug.org = > > > > > > = > > > > > > Does anyone remember back to IDS 8.21? By default, is there a way to fi= > > > nd > > > out > > > which users logged in and accessed the database over a given period of > > > time? I > > > am running on AIX 5.2. If there is a default log on AIX that keeps trac= > > > k of > > > > > > who logs in, that would work as well. > > > > > > 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. > > > > > > --001517448aac0e6af4047c701569 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Actually to be correct this is most definitely a XPS feature. The IDS feature actually came from XPS. If you look in the latest XPS documentation under. Using sysbdopen( ) and sysdbclose( ) Stored Procedures (XPS). Now I am not sure which version of XPS these were introduced, so they might not be in 8.21. 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 01/05/2010 11:45:43 AM: > [image removed] > > Re: IDS 8.21 on AIX 5.2 - log of users logging in [18546] > > Art Kagel > > to: > > ids > > 01/05/2010 11:46 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids. > > sysdbopen/sysdbclose are not supported in 8.xx, that's an 11.xx feature that > first appears in 11.10. > > Art > > Art S. Kagel > AdvanceDataTools (www.advancedatatools.com) > IIUG Board of Directors (art@iiug.org) > > See you at the 2010 IIUG Informix Conference > April 25-28, 2010 > Overland Park (Kansas City), KS > www.iiug.org/conf > > Disclaimer: Please keep in mind that my own opinions are my own opinions and > do not reflect on my employer, Oninit, the IIUG, nor any other organization > with which I am associated either explicitly or implicitly. 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 Tue, Jan 5, 2010 at 12:59 PM, LARRY SORENSEN <lsorensen25@msn.com> wrote: > > > In looking through the documentation, I did a search on sysdbopen for all > > of > > the PDF guides I have and nothing showed up. Can you direct me to somewhere > > that gives examples of how to use these? > > > > Larry > > > > > To: ids@iiug.org > > > From: miller3@us.ibm.com > > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18539] > > > Date: Tue, 5 Jan 2010 12:54:33 -0500 > > > > > > There is a simple way to accomplish this. You can > > > use sysdbopen() and sysdbclose() to track when user > > > connects and disconnects from each database. > > > > > > John F. Miller III > > > STSM, Support Architect > > > miller3@us.ibm.com > > > 503-578-5645 > > > IBM Informix Dynamic Server (IDS) > > > > > > = > > > > > > From: "LARRY SORENSEN" <lsorensen25@msn.com> = > > > > > > = > > > > > > To: ids@iiug.org = > > > > > > = > > > > > > Date: 01/05/2010 09:40 AM = > > > > > > = > > > > > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18538= > > > ] > > > > > > = > > > > > > Sent by: ids-bounces@iiug.org = > > > > > > = > > > > > > Does anyone remember back to IDS 8.21? By default, is there a way to fi= > > > nd > > > out > > > which users logged in and accessed the database over a given period of > > > time? I > > > am running on AIX 5.2. If there is a default log on AIX that keeps trac= > > > k of > > > > > > who logs in, that would work as well. > > > > > > 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. > > > > > > --001517448aac0e6af4047c701569 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
I did not find any reference to the stored procedures in 8.21 so they must have been introduced later. Isn't that always the case when you need something? :) > To: ids@iiug.org > From: miller3@us.ibm.com > Subject: Re: IDS 8.21 on AIX 5.2 - log of users logging in [18548] > Date: Tue, 5 Jan 2010 15:59:34 -0500 > > Actually to be correct this is most definitely a XPS feature. The > IDS feature actually came from XPS. If you look in the latest > XPS documentation under. > > Using sysbdopen( ) and sysdbclose( ) Stored Procedures (XPS). > > Now I am not sure which version of XPS these were introduced, so they > might not be in 8.21. > > 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 01/05/2010 11:45:43 AM: > > > [image removed] > > > > Re: IDS 8.21 on AIX 5.2 - log of users logging in [18546] > > > > Art Kagel > > > > to: > > > > ids > > > > 01/05/2010 11:46 AM > > > > Sent by: > > > > ids-bounces@iiug.org > > > > Please respond to ids. > > > > sysdbopen/sysdbclose are not supported in 8.xx, that's an 11.xx feature > that > > first appears in 11.10. > > > > Art > > > > Art S. Kagel > > AdvanceDataTools (www.advancedatatools.com) > > IIUG Board of Directors (art@iiug.org) > > > > See you at the 2010 IIUG Informix Conference > > April 25-28, 2010 > > Overland Park (Kansas City), KS > > www.iiug.org/conf > > > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and > > do not reflect on my employer, Oninit, the IIUG, nor any other > organization > > with which I am associated either explicitly or implicitly. 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 Tue, Jan 5, 2010 at 12:59 PM, LARRY SORENSEN <lsorensen25@msn.com> > wrote: > > > > > In looking through the documentation, I did a search on sysdbopen for > all > > > of > > > the PDF guides I have and nothing showed up. Can you direct me to > somewhere > > > that gives examples of how to use these? > > > > > > Larry > > > > > > > To: ids@iiug.org > > > > From: miller3@us.ibm.com > > > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18539] > > > > Date: Tue, 5 Jan 2010 12:54:33 -0500 > > > > > > > > There is a simple way to accomplish this. You can > > > > use sysdbopen() and sysdbclose() to track when user > > > > connects and disconnects from each database. > > > > > > > > John F. Miller III > > > > STSM, Support Architect > > > > miller3@us.ibm.com > > > > 503-578-5645 > > > > IBM Informix Dynamic Server (IDS) > > > > > > > > = > > > > > > > > From: "LARRY SORENSEN" <lsorensen25@msn.com> = > > > > > > > > = > > > > > > > > To: ids@iiug.org = > > > > > > > > = > > > > > > > > Date: 01/05/2010 09:40 AM = > > > > > > > > = > > > > > > > > Subject: RE: IDS 8.21 on AIX 5.2 - log of users logging in [18538= > > > > ] > > > > > > > > = > > > > > > > > Sent by: ids-bounces@iiug.org = > > > > > > > > = > > > > > > > > Does anyone remember back to IDS 8.21? By default, is there a way to > fi= > > > > nd > > > > out > > > > which users logged in and accessed the database over a given period > of > > > > time? I > > > > am running on AIX 5.2. If there is a default log on AIX that keeps > trac= > > > > k of > > > > > > > > who logs in, that would work as well. > > > > > > > > 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. > > > > > > > > > > --001517448aac0e6af4047c701569 > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
On Tue, Jan 5, 2010 at 10:01, Obnoxio The Clown <obnoxio@serendipita.com>wrote: > John Miller iii wrote: > > There is a simple way to accomplish this. You can > > use sysdbopen() and sysdbclose() to track when user > > connects and disconnects from each database. > > In XPS? > They (sysdbopen() and sysdbclose() were in XPS before they were in IDS - by a large margin. Whether they were in XPS 8.21 is a separate discussion. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Joan Crawford<http://www.brainyquote.com/quotes/authors/j/joan_crawford.html>; - "I, Joan Crawford, I believe in the dollar. Everything I earn, I spend." --000e0cd13b0ca01703047caf2aca