Re: ISAM error code -79 (No record locks available) when creating a n

Vince Here is what finderr -79 gave me: -79 No record locks available. An operating-system error code with the meaning shown was unexpectedly returned to the database server. This implementation of the Informix database server probably uses kernel locking, the use of the operating-system facilities to lock rows of tables. The capacity of the operating-system lock table has been exceeded. Contact your system administrator and inquire about configuring the operating system to support more locks. Also examine your database application to see if it can use fewer locks by updating fewer rows in each transaction or by locking whole tables instead of rows. You may want to check out your kernel config. Also by default database locking is page level locking, you can check yours by select tabname, locklevel from systables where tabid > 99 and tabtype = "T". HTH Sujit "Pachiano, Vince" <pachiano@bassinc.com> on 08/05/99 08:27:47 AM Please respond to "Pachiano, Vince" <pachiano@bassinc.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: ISAM error code -79 (No record locks available) when creating a n OK, I plead ignorance as to "our" record locking scheme. Actually, I believe we have none. I continue to receive this error, even after a cold-boot, and the system is essentially "quiet" Any pointers or gentle reminders? SE 05.00.UC6