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: