Re: ISAM error: out of locks

1. I agree with everything Clem says. 2. If you are getting this problem when doing large updates with no other users on the system you could use LOCK TABLE xxx IN EXCLUSIVE MODE within your transaction. This will only use up one lock for the whole table instead of a lock for each row affected. Ian Province wrote: > > 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)