RE: datase connectivity problem
Posted in 2000
Christina, My advice to you would be to review the IDS_7.2 document in $INFORMIXDIR/release/en_us/0333 First page you will find kernel parameters, you will also find kernel parameter suggestions on the last page. Review these with your Unix admin, they will be able to provide you with a kernel listing. Unless you wear 2 hats, in which case you can provide this yourself ;-) 109 connections - 1 userid? If so I would check the value of nproc this value specifies the number of processes a user may have active. While your at it check maxfiles and nfiles. By default these are usually fine but ya just never know who's been monkey'n around. It is my understanding that NETTYPE is primarily an optimization parameter for connections. But I may be wrong. I would appreciate comments on this. Hope this helps, Scott H. > ---------- > From: Christina Southam[SMTP:christina.southam@dla-law.co.uk] > Reply To: Christina Southam > Sent: Wednesday, January 05, 2000 10:16 AM > To: informix-list@iiug.org > Subject: datase connectivity problem > > We have an application which connects from client pcs (using informix > client > software) to an informix database (v7.22) running on SCO unix (v5.0.4.) > > Recently we have noticed that once we reach 109 connections to the > database > any subsequent connections hang/fail to connect. > > It has been suggested by Informix support that this is due to an operating > system kernel parameter as they say the informix side of things is > configured correctly. > > Has anyone seen this before/can anyone suggest what the parameter might > be??? > > Christina Southam > >