Re: Limit database connections

<color><param>0100,0100,0100</param>En Leigh Ann Chmura va escriure el dia 31 Jul 2000, a les 17:36: <italic><color><param>7F00,0000,0000</param>> I tried to set the NETTYPE parameter in the ONCONFIG file on a test > machine,and I couldn't get it to work. I set it #users to 2 and it > still let the third user connect. I want it to be a hard limit. > (Request from the bean counters) > > Informix Dynamic Server Version 7.31.UC2A -- On-Line -- Up 00:03:26 -- > 15248 K > > Userthreads > address flags sessid user tty wait tout locks nreads > nwrite > 4004e014 ---P--D 1 informix - 0 0 0 13 > 5 > 4004e500 ---P--F 0 informix - 0 0 0 0 > 2 > 4004e9ec ---P--F 0 informix - 0 0 0 0 > 0 > 4004eed8 ---P--F 0 informix - 0 0 0 0 > 0 > 4004f3c4 ---P--F 0 informix - 0 0 0 0 > 0 > 4004f8b0 ---P--F 0 informix - 0 0 0 0 > 0 > 4004fd9c ---P--- 5 informix - 0 0 0 0 > 0 > 40050288 ---P--B 6 informix - 0 0 0 0 > 0 > 40050774 Y--P--- 14 lam49 1 40199fcc 0 1 0 > 0 > 40050c60 Y--P--- 11 lam49 2 401988c4 0 1 22 > 0 > 4005114c ---P--D 9 informix - 0 0 0 0 > 0 > 40051638 Y--P--- 13 lam49 3 401998c8 0 1 0 > 0 > > This is what I put in the ONCONFIG file: > > NETTYPE soctcp,1,2,NET > > Did I miss something? > P.S.: OS: AIX 4.2.1 > Thank You! > > > "Art S. Kagel" wrote: > > > Leigh Ann Chmura wrote: > > > > > > Is there a way to limit the number of connections to the Informix > > > database? I know Informix works on the trust system as far as the > > > number of licenses, but I would like to limit it on my end. I am > > > running IDS 7.3.1 UC2A on a RS/6000 AIX 4.2.1 > > > > > > Any ideas would be helpful. > > > Thank You! > > > > Limit the number of listeners in the NETTYPE parameters in the > > ONCONFIG file. > > > > Art S. Kagel > </italic></color>Hi, ------ <color><param>0100,0100,0100</param>For all net types other than ipcshm, the poll threads dynamically reallocate resources to support more connections as needed. Avoid setting the value for the number of concurrent connections to much higher than you expect. Otherwise, you might waste system resources.<FontFamily><param>Times New Roman</param> ----- The max connections allowed in a NETTYPe are 32767. <FontFamily><param>Arial</param>Information extracted from Administration Guide Take care than a pool threads don't service more than 200 connections. I hope this helps. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes d'Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------