Total users
(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
(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?
+--------------------------------------------+--------------------+
| 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 |
+--------------------------------------------+--------------------+