RE: out of locks error

John If you delete 18000 rows from this table you will use 90000 locks...unless you have a delete trigger on this table which is doing something else in the database. How many locks did you see this for this process when you ran it? From what you say another process must have been using a significant number of locks at this time. If you are deleting many rows from this table one should.. Lock the table in exclusive mode. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of John David Adamski > Sent: Thursday, 7 August 2003 6:00 a.m. > To: informix-list@iiug.org > Subject: out of locks error > > > We have a table that is very dynamic and can change in size by +/- 20+ > thousand records in a day. Every once in a while when someone is > trying to delete their old records we get the out of locks error > message. > > We are running on HPUX HP Release B.11.00 and IDS 7.31 UC4, and have > 356000 locks configured in the onconfig. The table has row locking. > Today someone was trying to delete ~18000 of their 95000 records in > this table and got the out of locks message. All other users seemed > to have a hand full of locks. All other users had maybe a total of > 100 locks and they all where on other tables. > > So why did we get the error message? 18000 is not greater than > 356000, at least when I went to school. > > The table has 5 fields: > id (integer 4) > user_add_by (char 8) > add_date (date 4) > user_field (char 64) > list_name (char 16) > and 4 keys: > donly_id Dups id > idonly_index Unique id, user_add_by, add_date, > list_name, user_field > idonly_listname Dups list_name > idonly_user Dups user_add_by > > any ideas? sending to informix-list