SEO

#1 (**permalink**) 04-19-2008, 06:21 PM

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?

#2 (**permalink**) 04-19-2008, 06:21 PM

On 6 Aug 2003 11:00:27 -0700, adamski@graceland.edu (John David
Adamski) wrote:

>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?

As far as I know, the lock table is instance-specific, not
table-specific. Also, there will be a lock for each data row and each
index row as well.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode