Re: onstat -u

Hi, "128 total" means the initial size of your user table. When you will need 129 concurrent sessions, Informix will add an additional table with again 128 entries. The USERTHREADS table changed from a static size ( pre 7.10UD1 ) to a dynamic size. Bye Stefan Weideneder Harold Luse wrote: > > Here's a good question. > > Sample: > > 4004d214 Y--P--- 4999 dbolte 91 40c936d8 > 4004d654 Y--P--- 4965 tgreenwa 56 40129f98 0 1 2071 > 4004ded4 Y--P--- 4484 bhitchen 32 40b4c5c0 0 1 136 > 4004e314 Y--P--- 5023 hwhite 77 40006f8c 0 1 2430 > 4004efd4 Y--P--- 4917 sbrown 67 40d7d744 0 1 109 > 66 active, 128 total, 81 maximum concurrent > > When using onstat -u the last line shows active, total and maximum > concurrent. Active is the number of current session threads, and maximum > concurrent is the peak number since last re-boot. The question is, how is > the total figure computed? > > Any one with any clue please feel free to expound. > > ==================================================================== > Harold Luse > Applications Programmer Phone: (970) 491-4120 > Veterinary Teaching Hospital Fax: (970) 491-1275 > Colorado State University Pager: (970) 229-8173 > Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu > ====================================================================