Transaction processing uses an exclusive lock. To activate an exclusive lock on a table, use the SET LOCK tblname ON command. This command remains in effect until a corresponding SET LOCK tblname OFF command is issued to remove the lock from that table. Only the user who sets the lock can remove it.
SET LOCK tblname OFF commands take effect when you end the current transaction with the COMMIT or ROLLBACK command. You should remove exclusive table locks as soon as the table is no longer needed, especially when working in multi-user mode. Exclusive locks are removed automatically when you exit a database, or when you run the recovery program following a processing interruption.
Transaction Processing Topics:
Locking Table Access and Resource Waiting
Row Locks and Transaction Processing
Automatic Table and Database Locks
Displaying Transaction Processing Locks
Resource Waiting in Transaction Processing
