Re: Online - Lock table overflow

Paul Thomas Mahoney writes: >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? To prevent row-level locks, you must use EXCLUSIVE table-level locks. Shared table locks will not prevent exclusive row locks from being placed. Dave -- Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney