user connection high water mark
Hey all, Is there a table that stores user connections? I've been given the task of reporting how many users are connecting to our informix databases and recording a high water mark. Anybody know any good ways of checking on this? Thanks!
As usual, the answer depends on which release you're using. For IDS 11.50
(not sure about 10.,00), the DBMS records the high-water mark for each
week, keeping 5 years of history, in the sysmaster:sysfeatures view. Those
are the only supported releases now. If you're running IDS 7.31 or 9.40,
they you'll have to periodically check onstat -u or onstat -g ses or
onstat -g ntt and record your own results.
Cheers,
Dick
From:
"STEVEN MITTELSTAEDT" <steven.mittelstaedt@gmail.com>
To:
ids@iiug.org
Date:
11/10/09 11:50 AM
Subject:
user connection high water mark [18033]
Sent by:
ids-bounces@iiug.org
Hey all,
Is there a table that stores user connections? I've been given the task of
reporting how many users are connecting to our informix databases and
recording a high water mark. Anybody know any good ways of checking on
this?
Thanks!
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
grep 'Maximum server connections' in server message log. - Nilesh - ids-bounces@iiug.org wrote on 11/10/2009 10:48:35 AM: > [image removed] > > user connection high water mark [18033] > > STEVEN MITTELSTAEDT > > to: > > ids > > 11/10/2009 10:50 AM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > Hey all, > > Is there a table that stores user connections? I've been given the task of > reporting how many users are connecting to our informix databases and > recording a high water mark. Anybody know any good ways of checking on this? > > Thanks! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
sysmaster:syssessions Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) 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, Nov 10, 2009 at 11:48 AM, STEVEN MITTELSTAEDT < steven.mittelstaedt@gmail.com> wrote: > Hey all, > > Is there a table that stores user connections? I've been given the task of > reporting how many users are connecting to our informix databases and > recording a high water mark. Anybody know any good ways of checking on > this? > > Thanks! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000e0cd1e174f13f0f047808108e
> Hey all,
>
> Is there a table that stores user connections? I've been given the task of
> reporting how many users are connecting to our informix databases and
> recording a high water mark. Anybody know any good ways of checking on
> this?
>
errrrm, doesn't the last line of
onstat -u
say a maximum concurrent? Then subtract the first dozen or from the listing
that are marked as system processes.