user connection high water mark
Steven Mittelstaedt asked how to record a high-water mark of user connections. Richard Snoke said IDS 11.50 keeps weekly highs in the sysmaster sysfeatures view, while 7.31 and 9.40 need periodic onstat -u, -g ses or -g ntt checks. Nilesh Ozarkar suggested the message log's Maximum server connections, Art Kagel syssessions, Andrew Clarke the last line of onstat -u.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.