Online - Lock table overflow
Posted in 1992
Situation:
I have Online 4.10 configured to support 10000 locks.
All my tables are set for row level locking.
I have 13 BIG files, in "unload" format, to load into 13 tables
Problem with following sql:
begin work;
lock table table_01 in share mode;
...
lock table table_13 in share mode;
load from "file_01" insert into table_01; ...
load from "file_13" insert into table_13;
commit work;
Having managed to load the first 2 tables it gets 3313 rows
into table_03 and generates error 271 - Can't insert new row.
All the remaining 10 loads fail imediately with the same error.
In turbo.log I see 11 "Lock table overflow" messages.
Now I thought I would not have any lock table overflow problems
because I had lock the tables so no row level locking would be
required.
If I change the table lock mode to "exclusive" mode it works!
Can some tell me what I missed?
--
Paul Mahoney, X-Act Solutions Limited
smail: 20 Shipley Lane, Cooden, Bexhill-on-Sea, East Sussex, TN39 3SR
email: ptm@xact.demon.co.uk ... pmahoney@cix.compulink.co.uk
phone: +44 424 3 6368