Re: Informix on SuSE Linux 6.2

costan999@my-deja.com wrote: > > In article <83lpac$6qi$1@nnrp1.deja.com>, > Art S. Kagel <kagel@bloomberg.net> wrote: > > In article <83kssu$jg1$1@nnrp1.deja.com>, > > costan999@my-deja.com wrote: [Earlier discussion SNIPPED] > Can you help me with ids 7.30 ? I can't make more than 50 connection > to database server. I'm trying to upgrade/migrate from informix online 5 > (SCO UNIX 3.2 4.2) to informix dynamic server 7.30 (Linux 2.2.5-15) > In ids 5 there was some shared memory parameter: > "Max # of User" > > Here's (in ids7) no that parameter... > May be i have to modify some kernel parameters: > SEMMNS, SEMMNI, SEMMAP etc ? > > I have no idea about it... > does it linux_kernel/ids7.30[trial_copy]/configuration > limitation or because i'm a new to linux ;) No. The ONCONFIG file parameter NETTYPE configures the listeners and replaces the OL5.xx parameter USERS to configure the number of concurrent users that can attach using a particular protocol. The default if there is no NETTYPE for a protocol, or if the NETTYPE does not specify a value, is 50 connections. To change the shared memory try: NETTYPE ipcshm,1,100,CPUThis configures one shared memory listener thread (you should have one in each CPU VP you have configured in NUMCPUVPS) with 100 connection slots in a CPU VP for EACH DBSERVERNAME or DBSERVERALIAS that uses shared memory (protocol onipcshm in the sqlhosts file). If you have more listners configured (#listeners per connection name in the NETTYPE times the number of shared memory connection names) than CPU VPs then NET VPs will be started for the balance. and for TCP try: NETTYPE soctcp,1,100,NET This starts one NET VP to listen for ALL TCP connections with 100 slots for each DBSERVERNAME or DBSERVERALIAS that uses onsoctcp in the sqlhosts file. Art S. Kagel

In article <385FA8D4.5F3306F3@bloomberg.net>, kagel@bloomberg.net wrote: > [Earlier discussion SNIPPED] > > No. The ONCONFIG file parameter NETTYPE configures the listeners and > replaces the OL5.xx parameter USERS to configure the number of concurrent > users that can attach using a particular protocol. The default if there is > no NETTYPE for a protocol, or if the NETTYPE does not specify a value, is > 50 connections. To change the shared memory try: > > NETTYPE ipcshm,1,100,CPU> This configures one shared memory listener thread (you should have one in > each CPU VP you have configured in NUMCPUVPS) with 100 connection slots in > a CPU VP for EACH DBSERVERNAME or DBSERVERALIAS that uses shared memory > (protocol onipcshm in the sqlhosts file). If you have more listners > configured (#listeners per connection name in the NETTYPE times the number > of shared memory connection names) than CPU VPs then NET VPs will be started > for the balance. > > and for TCP try: > > NETTYPE soctcp,1,100,NET> > This starts one NET VP to listen for ALL TCP connections with 100 slots for > each DBSERVERNAME or DBSERVERALIAS that uses onsoctcp in the sqlhosts file. It worked...;) Thanks. > > Art S. Kagel > Costan Sent via Deja.com http://www.deja.com/ Before you buy.