You can use the LIST or LIST TABLES command to see which locks are in place; when transaction processing is on, the names of locked tables are listed with the LIST command in reverse video.
Types of locks displayed with the LIST TABLES command:
Lock |
Description |
Local SELECT lock |
A command issued from this workstation holds a SELECT lock |
Remote SELECT lock |
A command issued from another workstation holds a SELECT lock |
Local INSERT lock |
A command issued from this workstation holds an INSERT lock |
Remote INSERT lock |
A command issued from another workstation holds an INSERT Lock |
Local UPDATE lock |
A command issued from this workstation holds an UPDATE lock |
Remote UPDATE lock |
A command issued from another workstation holds an UPDATE Lock |
Local lock |
SET LOCK issued from this workstation holds an exclusive lock |
Remote lock |
SET LOCK issued from another workstation holds an exclusive lock |
Transaction Processing Topics:
Locking Table Access and Resource Waiting
Row Locks and Transaction Processing
Automatic Table and Database Locks
Resource Waiting in Transaction Processing
Generate a Transaction Journal
Recovering from Transaction Processing Errors
