RE: Script for determining the number of user lice
A user asked for the script IBM auditors use to count user licences for IDS. The answer given (confirmed by IBM as correct for IDS 10 and 11): select sh_curmaxcons, sh_ovlmaxcons from sysmaster:sysshmvals — note these are high-water marks of concurrent sessions (since last restart and since rootdbs initialisation), not current counts, and they only ever increase. It counts real user sessions, not PDQ threads or internal threads like page cleaners. For 11.50, sysmaster:sysfeatures was suggested, holding weekly maximum usage (connections, VPs, memory, size) for five years. The asker was satisfied.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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.
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.
What version of IDS?? The answer varies with the version. Dick Snoke IBM Data Management - ChannelWorks dsnoke@us.ibm.com (404) 487-1595 From: "LARRY SORENSEN" <lsorensen25@msn.com> To: ids@iiug.org Date: 06/26/09 09:53 AM Subject: RE: Script for determining the number of user .... [16168] Sent by: ids-bounces@iiug.org 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.
I need it for both IDS 10 and IDS 11. > To: ids@iiug.org > From: dsnoke@us.ibm.com > Subject: RE: Script for determining the number of user .... [16171] > Date: Fri, 26 Jun 2009 10:34:52 -0400 > > What version of IDS?? The answer varies with the version. > > Dick Snoke > IBM Data Management - ChannelWorks > dsnoke@us.ibm.com > (404) 487-1595 > > From: > "LARRY SORENSEN" <lsorensen25@msn.com> > To: > ids@iiug.org > Date: > 06/26/09 09:53 AM > Subject: > RE: Script for determining the number of user .... [16168] > Sent by: > ids-bounces@iiug.org > > 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. >
The previously posted query is correct for both IDS 10 and 11. Other
things are required for the older releases. I understand your need to
demonstrate the validity of the numbers by showing some detail using
onstat reports. However, the auditors will rely on those values in the
sysmaster database.
Dick Snoke
IBM Data Management - ChannelWorks
dsnoke@us.ibm.com
(404) 487-1595
From:
"LARRY SORENSEN" <lsorensen25@msn.com>
To:
ids@iiug.org
Date:
06/26/09 10:44 AM
Subject:
RE: Script for determining the number of user .... [16172]
Sent by:
ids-bounces@iiug.org
I need it for both IDS 10 and IDS 11.
> To: ids@iiug.org
> From: dsnoke@us.ibm.com
> Subject: RE: Script for determining the number of user .... [16171]
> Date: Fri, 26 Jun 2009 10:34:52 -0400
>
> What version of IDS?? The answer varies with the version.
>
> Dick Snoke
> IBM Data Management - ChannelWorks
> dsnoke@us.ibm.com
> (404) 487-1595
>
> From:
> "LARRY SORENSEN" <lsorensen25@msn.com>
> To:
> ids@iiug.org
> Date:
> 06/26/09 09:53 AM
> Subject:
> RE: Script for determining the number of user .... [16168]
> Sent by:
> ids-bounces@iiug.org
>
> 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.
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.
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.
For those on 11.50 I would look at a table called sysmaster:sysfeatures.
This will
give usage information by week. The information will be kept for 5 years.
The
information in each row tracks the maximum usage for that week.
Hope it helps,
week 26
year 2009
version 11.50.FC4
max_cpu_vps 1
max_vps 7
max_conns 1
max_sec_conns 0
max_sds_clones 0
max_rss_clones 0
total_size 541 MB
total_size_used 120 MB
max_memory 211 MB
max_memory_used 148 MB
is_primary 0
is_secondary 0
is_sds 0
is_rss 0
is_er 0
is_pdq 0
week 25
year 2009
version 11.50.FC4
max_cpu_vps 1
max_vps 7
max_conns 1
max_sec_conns 0
max_sds_clones 0
max_rss_clones 0
total_size 541 MB
total_size_used 120 MB
max_memory 211 MB
max_memory_used 152 MB
is_primary 0
is_secondary 0
is_sds 0
is_rss 0
is_er 0
is_pdq 0
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 06/26/2009 09:08:41 AM:
> [image removed]
>
> RE: Script for determining the number of user .... [16175]
>
> Richard Snoke
>
> to:
>
> ids
>
> 06/26/2009 09:10 AM
>
> Sent by:
>
> ids-bounces@iiug.org
>
> Please respond to ids
>
> 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.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Thank you all for the information.
> To: ids@iiug.org
> From: miller3@us.ibm.com
> Subject: RE: Script for determining the number of user .... [16178]
> Date: Fri, 26 Jun 2009 18:43:55 -0400
>
> For those on 11.50 I would look at a table called sysmaster:sysfeatures.
> This will
> give usage information by week. The information will be kept for 5 years.
> The
> information in each row tracks the maximum usage for that week.
>
> Hope it helps,
>
> week 26
> year 2009
> version 11.50.FC4
> max_cpu_vps 1
> max_vps 7
> max_conns 1
> max_sec_conns 0
> max_sds_clones 0
> max_rss_clones 0
> total_size 541 MB
> total_size_used 120 MB
> max_memory 211 MB
> max_memory_used 148 MB
> is_primary 0
> is_secondary 0
> is_sds 0
> is_rss 0
> is_er 0
> is_pdq 0
>
> week 25
> year 2009
> version 11.50.FC4
> max_cpu_vps 1
> max_vps 7
> max_conns 1
> max_sec_conns 0
> max_sds_clones 0
> max_rss_clones 0
> total_size 541 MB
> total_size_used 120 MB
> max_memory 211 MB
> max_memory_used 152 MB
> is_primary 0
> is_secondary 0
> is_sds 0
> is_rss 0
> is_er 0
> is_pdq 0
>
> 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 06/26/2009 09:08:41 AM:
>
> > [image removed]
> >
> > RE: Script for determining the number of user .... [16175]
> >
> > Richard Snoke
> >
> > to:
> >
> > ids
> >
> > 06/26/2009 09:10 AM
> >
> > Sent by:
> >
> > ids-bounces@iiug.org
> >
> > Please respond to ids
> >
> > 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.
> >
> >
> >
>
>
*******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>