Hi there,

I am using DB2 7.1 and I am trying to lock a table in exclusive mode with the following command:

lock table sequence_number in exclusive mode

The command completes successfully.

I am under the assumption that this should prevent any reads (except UR) from the sequence_number table. However I am still able to execute a select statement from another transaction with the command:

select * FROM sequence_number with RR

Am I missing something obvious here?


Thank you and best wishes,

LOCK TABLE statement holds the lock until the next commit. If your LOCK TABLE session had autocommit, then the lock would have been released.

Issue
db2 +c lock table sequence_number in exclusive mode

Issue your select statement in the other window and now it should work !!!

Great, thanks allot - it works well now


Best wishes,

as well you can change autocommit dynamicly in your script:

--disable autocommit
update command options using c off@
lock table mytable in exclussive mode@
update...
delete...
insert...
commit@
-- switch to autocommit
update command options using c on@