Re: Let me be the first

Lukas, if the below fails then I still think you are using page level rather than row level locking > I use IDS 10.0 on Windows. > Here is statement sequention to demonstrate my problem: > > Thread1: > UPDATE TABLE table1 SET col1=10 WHERE col2=15; > .... further processing for 10 minutes.... > > > Thread2: > SELECT * FROM TABLE table1 WHERE col2=20;> (locked until thread1 finished). >

scottishpoet wrote: >Lukas, if the below fails then I still think you are using page level >rather than row level locking > > Not at all: The number of rows in the table is small enough to cause the database server to perform a sequential scan, and an index scan on a table with lock mode configured to row. It's my fault :-( If I looked at access plan I could resolve this problem myself. Informix gave me a good lection of database implementation. Lukas