Re: Counting Sessions

On Dec 4, 2:04 pm, Nog <n...@gfm.co.uk> wrote: > On Dec 4, 12:23 pm, "Art S. Kagel" <art.ka...@gmail.com> wrote: > > > > > On Dec 4, 7:14 am, Nog <n...@gfm.co.uk> wrote: > > > > Hi, > > > > I'm Using IDS V10.00.UC5 on SUSE linux. > > > > I want to keep a count the number of sessions occurring hourly/daily > > > on my instance. I was using a cron script to execute the following > > > sql and store the result hourly; > > > > select DBINFO('sessionid') from systables where tabid = 99; > > > > Then I thought I could simply subtract the last session id from the > > > current one to get the number of sessions used in that hour period. > > > This doesn't seem to work as sometimes sessionids are smaller than ids > > > taken from an earlier period. > > > > Anyone know if there's another way to do this? > > > > ta > > > I've never seen session ids go down. Is it possible that your session > > ids are wrapping past 2^31 and starting over? > > > Art S. Kagel > > No, it's not starting over as the id's go up again after the spurious > one, here's an snippet from a fews days ago; > > Hour Session ID sessions count > 01:00 27703795 --- > 02:00 27715073 11278 > 03:00 27720194 5121 > 04:00 27722863 2669 > 05:00 27721660 -1203 > 06:00 27730787 9127 > 07:00 27732274 1487 > > anyone know of any good documentation on session id's and how they're > generated? Thank you all for your suggestions, Cesar Inacio Martins suggested the following which I'm going to use, unless anyone knows of a reason not to; onstat -g ntu | awk '$2 == "connects"{ getline; print $3 } ' thanks again

"Nog" <noel@gfm.co.uk> wrote in message news:873c1a7b-c863-41b0-ad19-92afa29369d1@i12g2000prf.googlegroups.com... > On Dec 4, 2:04 pm, Nog <n...@gfm.co.uk> wrote: > Thank you all for your suggestions, > > Cesar Inacio Martins suggested the following which I'm going to use, > unless anyone knows of a reason not to; > > onstat -g ntu | awk '$2 == "connects"{ getline; print $3 } '> > thanks again If you are by any chance doing this for an IBM self-assessment audit, do yourself a favour and call an IBM Business Partner to help you.