Re: ISAM error: out of locks

Sham Vaidya wrote: Just in case you are not using the OnLine server and you are using the SE database then the following applies: You will need to tune the UNIX kernel on your system and increase the number of system locks. I don't think there is still a version of SE out there that using flock so we won't even talk about that one. >Hi, > >I'm assuming the UNIX DB server is OnLine and the answer is OnLine >related. However, the other Informix DB server's should have the same >concept in them. > >There is the LOCKS field in the onconfig file that get set during >DB initialization. This field allows the dbadmin to set the maximum >number of locks that the database can allow. Another place for setting >the same field (LOCKS - max number of locks) is in the onmonitor utility, >parameters/Shared-Memory screen. this screen is accessible only to the >dba. Informix OnLine needs to be in an quiescent/off-line mode to make >these changes. > >Sham Vaidya >smvaidya@auto.rockwell.com > >In article <01bbec4c$916e1180$180919c4@prov9>, "Province" says... >> >>I received the ISAM error "-134 No more locks" together with the -908 error >> for quite a long time now trying to access the UNIX server. >> >>Can anyone give me a reason to this, or better still, a solution to the >>problem? I am doing a project for Athletics South Africa and I'd like it to >>be finished before the next Olympics. I get the error for example in >>dbschema and dbaccess. Any help would be appreciated, since this was my >>first encounter with Informix. >> >>Regards >>Lohan Johnson (lohan@technologix.co.za) _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP 25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555 Email gordonh@thehub.com.au _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year Pink Floyd