Re: connection problem

Csom Gyula wrote: > Hi everyone, > did someone meet the following issue? > > We use Informix Online 5.00 UC2 on a Unix box (AT&T UNIX SYSTEM V > Release 4.0). Currently only 91 users can connect to the database. > Afterwards no new user can login - till someone logs out and the user > can connect to the server, Informix fires error messages (see below). Problem 1: 5.00 OnLine has been out of date for a decade, and formally totally unsupported since 2000-01-01. You need to upgrade - urgently - preferably before you have a crash and need to recover from backups. You might be OK, but you might not. What do you have set in the TBCONFIG file for number of users? I would suspect 100; and with a few administrative processes around, 91 represents the number of usable connections. Set that parameter higher and restart the server. > We tried to tune the operating system according to a 7.23 machine notes (http://www-3.ibm.com/software/data/informix/pubs/library/notes/machnote/ncr/723uc1nc.htm). However this didn't resolve the issue. No great surprise - the connection mechanisms in 5 and 7+ are completely different. In 5, each connection has its own sqlturbo process, which communicate with a shared tbinit (and the odd tbpgcl and tbundo processes - the administrative processes to which I referred). In 7, you have a (small) collection of oninit processes serving all the clients that connect. > The following error message is sent by Informix Star: > > sqAU0BPQAAsqlexec Szoszi kkieg -p > sqAU0BPQAAsqlexec Szoszi kkieg -p > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > 25519 The sqlexecd daemon cannot open the network device.: System error: No space left on device > sqAU0BPQAAsqlexec Szoszi kkieg -p > > Any hint, help would be highly appriciated. The other possibility is that the sqlexecd has run out of file descriptors, or some other network resource. Not sure about why - the master daemon should be closing them as it goes, and the child sqlturbos it forks off should only be using a few file descriptors (primarily standard input and standard output - usually to the same socket) plus any chunks etc it uses. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/