RE: out of locks error

It takes a lock for each record and a lock for each key. Change locking to table for this one delete. -----Original Message----- From: adamski@graceland.edu [mailto:adamski@graceland.edu] Sent: Wednesday, August 06, 2003 2:00 PM 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