Re: Total users
In article <504olm$3do@cssun.mathcs.emory.edu>, Schuyler Southwell
<ssouthwe@pcshs.com> writes
>(Informix OnLine DS 7.12.UC5, 150 user license on Sparc1000 Solaris 2.4)
>
>This question is prompted by a certain nervousness caused by the following:
>
>Last line of onstst -u (on a slow day)
> 85 active, 128 total, 99 maximum concurrent
>
85 = number of current threads in existence.
128 = maximum number of threads allowed at any one time i.e. the
limit.
99 = ?? Maximum number of threads in existence at any one time
since the server started.
My v7 Admin is a bit unclear about this but I do know that Informix
licensing works in powers of 2 - 16,32,64...see below.
>(and, yes, most of these are 'REAL' user threads, not DS threads or some other
>misleading count)
>
>The Manual says (Administrator's Guide Volume 2, onstat -u description)
> "The number of active users and the maximum number of users
> allowed are also indicated. The maximum number of
> concurrent user threads is specified as USERTHREADS in
> the ONCONFIG file."
>
>Our release notes state
> 11. The following configuration parameters have been eliminated:
> USERTHREADS, TRANSACTIONS, TBLSPACES, DBSPACES and CHUNKS.
> INFORMIX-OnLine Dynamic Server Version 7.10.UD1 allocates resources
> dynamically for the structures that these parameters controlled in
> previous releases.
>
>Why is the "maximum number of users allowed" 128, and not 150?
>
>The "maximum concurrent" is the dynamic replacement for the USERTHREADS
>parameter, yes? This will increase as demands increase?
>
>What happens when 85 or 99 reach the 128 total?
>
You get an error saying that the limit has been reached 7.12 and above
DO enforce user licensing limits.
>+--------------------------------------------+--------------------+
>| Schuyler L. Southwell (ssouthwe@pcshs.com) | PCS Health Systems |
>| Lead Database Administrator | 9501 E. Shea Blvd |
>+--------------------------------------------+ Scottsdale, AZ |
>| Voice: 602-661-3071 FAX: 602-391-4850 | 85260 6719 |
>+--------------------------------------------+--------------------+
From a previous post in comp.databases.informix:-
From: Ken Lenagh <kalenagh@wtc.com>
For version 7.x the number of users is determined by the serial
number that you enter during the install of the product.
This is an excerpt of the file /$INFORMIXDIR/etc/install
case $USERCODE in
A) NUMUSER=1; SINGLUSR=true;;
B) NUMUSER=8;;
C) NUMUSER=16;;
E) NUMUSER=32;;
F) NUMUSER=64;;
G) NUMUSER=128;;
H) NUMUSER=256;;
J) NUMUSER=unlimited; LIMIT=false;;
V) NUMUSER=unlimited; LIMIT=false; EVAL=true;;
the letter code refers to the alpha character following the # in
the serial number. i.e AAB#A is a single user licence and AAB#J
is an unlimited license (add as many users as you like).
--
David Williams