Re: ISAM error: out of locks

Another option is to commit the transactions more often. Munir Noorali noorm@scsn.net http://www.scsn.net/users/noorm/ Sham, Vaidya wrote: > > 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)