The LIST LOCKS command displays all locks currently held by transaction recovery.
LIST LOCKS ;
The report displays the mode of the lock held (write or exclusive), the object type locked (database, table, row range, or row hash) and the name of the object. The report is sorted alphabetically by object name.
For row range and row hash locks, the row information does not display. Only the table within which the row resides is displayed.
If rcvmanager is unable to determine the database name associated with an object, rcvmanager displays the database ID in decimal and hex. The same is true if the table name cannot be determined.
LIST LOCKS displays only those locks currently held by transaction recovery. You cannot display locks held by online catchup or offline catchup.
Example: Displaying a list of locks held by transaction recovery
Only a single report is generated by the LIST LOCKS command. An example of this report is shown below:
LOCKS HELD BY ONLINE TRANSACTION RECOVERY at 02:29:16 04/06/16 Lock Lock Object Mode Object Name ---- ------ ---- Write Database "AssetsDB" Write Row hash "Clients"."TurnOver" Write Row hash "EmployeeInfo"."NewHires" Exclusive Table "SampleDB"."SampleTable"