Re: Limit database connections

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 No there isn't. I think shared memory connections still get limited, but all others dynamically allow connections past your NETTYPE setting. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+

We have the same problem, it's handy from time to time though. The only thing I can suggest, and this is a cludge but it helps is to either: 1) Put a check to onstat -u when the users login and boot them, ours never see commandline so this helps a fair chunk. 2) Put custom scripts in place to replace isql/dbaccess/etc which call the same check and if ok, call the real isql/etc I know these don't cover all situations, but they help brett > > 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 > > No there isn't. I think shared memory connections still get limited, but > all others dynamically allow connections past your NETTYPE setting. > > Cheers, >

Mark D. Stock wrote in message <8m7i5j$79f$1@news.xmission.com>... > >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 > >No there isn't. I think shared memory connections still get limited, but >all others dynamically allow connections past your NETTYPE setting. > When will this be fixed so that shared memory access the same as the others? I asked UK Tech Support about a feature request but they did not seem interested.. >Cheers, >-- >Mark. > >+----------------------------------------------------------+-----------+ >| Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| >| http://www.informix.com http://www.informixhandbook.com |///// / //| >| http://www.iiug.org +-----------------------------------+//// / ///| >| |This email will self-destruct in |/// / ////| >| |10 sec. If you received this email |// / /////| >| |in error, sorry about the mess. |/ ////////| >+----------------------+-----------------------------------+-----------+