Re: out of locks error

On Wed, 06 Aug 2003 14:00:27 -0400, John David Adamski wrote: Well, there will be a lock for each row and for each index key so that makes 18000 * 5 or 90000. If this is a parent to another table with a foreign key constraint with cascading delete enabled there would be the locks on all of the child records and their keys. Plus the lock table is shared by all users so how many of those ~100 lock users are there concurrently? Art S. Kagel > 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?