yevgeni123
Programmer
Hello to everyone
I'm completely new in Informix but had a lot of experience with DB2
Here is my problem:
Assume that my TABLE has an integer ZZZ column. Further assume that I explicitly create an index on ZZZ.
Table was created lock mode ROW and ZZZ as primary key
Now consider this "start of transaction":
set isolation to repeatable read;
begin;
select * from TABLE where ZZZ=5;
I expected that it should place a lock ONLY ON those records for which the value of ZZZ=5.
In my case ZZZ is a primary key , so there is only one record where ZZZ=5
Now ...
running onstat -k, I see that the WHOLE TABLE IS LOCKED (rowid=0).
Since part of my design relies on the expected behavior of repeatable read, what am I missing?
Thanks in advance for any help !
I'm completely new in Informix but had a lot of experience with DB2
Here is my problem:
Assume that my TABLE has an integer ZZZ column. Further assume that I explicitly create an index on ZZZ.
Table was created lock mode ROW and ZZZ as primary key
Now consider this "start of transaction":
set isolation to repeatable read;
begin;
select * from TABLE where ZZZ=5;
I expected that it should place a lock ONLY ON those records for which the value of ZZZ=5.
In my case ZZZ is a primary key , so there is only one record where ZZZ=5
Now ...
running onstat -k, I see that the WHOLE TABLE IS LOCKED (rowid=0).
Since part of my design relies on the expected behavior of repeatable read, what am I missing?
Thanks in advance for any help !