IDS Forum

RE: Script for determining the number of user ....

Posted By: Richard Snoke
Date: Friday, 26 June 2009, at 12:08 p.m.

In Response To: RE: Script for determining the number of user .... (Peter_Logan@spartanstores.com)

Yes, that query is the correct count of the sessions (not threads)
established by real users, without counting the page cleaners, etc. that
are reported by onstat -u. The counter is sessions, not threads. The
counter, as has been noted, is the high-water mark, not the current count.
The counters only increase, never decrease. In addition, there's no
record kept of when that high-water mark was reached. That would be a
useful addition.

Dick Snoke
IBM Data Management - ChannelWorks
dsnoke@us.ibm.com
(404) 487-1595

From:
"Peter_Logan@spartanstores.com" <Peter_Logan@spartanstores.com>
To:
ids@iiug.org
Date:
06/26/09 11:48 AM
Subject:
RE: Script for determining the number of user .... [16174]
Sent by:
ids-bounces@iiug.org

does this script take into account when a single user has spawned off
several other threads ... for example doing some PDQ stuff ... onstat -u
will show a bunch of sessions for the one session ... Also, does it strip
out the extra session that onstat -u shows when an instance has been
initialized, but no users are connected ....

Peter Logan
Senior Database Administrator
Phone: 616/878-8309

From:
"Everett Mills" <Everett.Mills@nationalbeef.com>
To:
ids@iiug.org
Date:
06/26/2009 10:08 AM
Subject:
RE: Script for determining the number of user .... [16170]
Sent by:
ids-bounces@iiug.org

This is the sql script that the IBM auditors are using:

select sh_curmaxcons CURRENT_USERS, sh_ovlmaxcons MAX_USERS
from sysmaster:sysshmvals

Note that as I observed to the auditors, sh_curmaxcons doesn't count
current sessions, it counts the maximum number of concurrent sessions
(both external and internal) since the server was last restarted.
sh_ovlmaxcons counts the maximum number of concurrent sessions since the
rootdbs was initialized. I provided them with the output from onstat -u
| grep max for every run of their script to hammer that point home.

--EEM

> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
LARRY
> SORENSEN
> Sent: Friday, June 26, 2009 8:53 AM
> To: ids@iiug.org
> Subject: RE: Script for determining the number of user .... [16168]
>
> Does anyone have access to the script that IBM uses to determine how
many user
> licenses are required for IDS licensing? I need to run this to ensure
> compliance.
>
> Thanks.
>
>
>
************************************************************************
******
> *
> 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.

Messages In This Thread

• RE: Script for determining the number of user lice
  LARRY SORENSEN -- Friday, 26 June 2009, at 9:52 a.m.
  • RE: Script for determining the number of user ....
    Everett Mills -- Friday, 26 June 2009, at 10:08 a.m.
    • RE: Script for determining the number of user ....
      Peter_Logan@spartanstores.com -- Friday, 26 June 2009, at 11:46 a.m.
      • RE: Script for determining the number of user ....
        Richard Snoke -- Friday, 26 June 2009, at 12:08 p.m.
        • RE: Script for determining the number of user ....
          John Miller iii -- Friday, 26 June 2009, at 6:43 p.m.
          • RE: Script for determining the number of user ....
            LARRY SORENSEN -- Monday, 29 June 2009, at 9:21 a.m.
  • RE: Script for determining the number of user ....
    Richard Snoke -- Friday, 26 June 2009, at 10:34 a.m.
    • RE: Script for determining the number of user ....
      LARRY SORENSEN -- Friday, 26 June 2009, at 10:43 a.m.
      • RE: Script for determining the number of user ....
        Richard Snoke -- Friday, 26 June 2009, at 11:27 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.