Re: Unnecessary Locks -- Help!

"Chao Y. Din" <cdin@explorer.csc.com> wrote: >We have experienced locking problems from a new program we developed. >We subsequently developed the following test cases. >All test cases are using the same table A with key -- char(11), col -- >char(2), and all sqls are using repeatable read. >case 1: > from one telnet session: > insert into A (key, col) values ("A00000B0001", null);> row inserted > from another telnet session: > insert into A (key, col) values ("A00000B0002", null);> key value lock You don't say which version of Online you are using. We had this problem on 7.11 and 7.12, and it should be fixed in 7.20. It only occurs on adjacent keys when you have a composite index. Our solution was to use a single column index. David W Chan GO5 Limited david@go5.com (work) dwc@cix.compulink.co.uk (home)