RE: Number of the lock requests

I would assume you are using IDS 7.x. And you are using row locking for your table. Whenever, Informix does an update it locks both the data and index. It will also lock data and index from another table if it has a referential constraint. So if you have 25000 records and assuming the table has an index. You could consume at least 50000 locks is you are using row locking. You have several options to make your operation successful. One is increase the value of LOCKS (I think 40000 is too low anyway). Or you can change the lock mode of the table(s) to page. Don -----Original Message----- From: Rozsnyai, Andor (MED) [mailto:Andor.Rozsnyai@med.ge.com] Sent: Tuesday, November 21, 2000 5:14 AM To: informix-list@iiug.org Subject: Number of the lock requests Hi, We have some joined tables in a simple line structure. If I want to delete everything I have a message that no enough locks. My problem is that I have 25000 items in all tables and 40000 locks. Could anyone explain me the relationship between the lock request and the number of the records. Thank you, Andor Rozsnyai