The LIST LOCKS command displays all locks currently held by transaction recovery.
to displays locks held by online transaction recovery.
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.
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
Lock Lock Object
Mode Object Name
---- ------ ----
Write Database "AssetsDB"
Write Row hash "Clients"."TurnOver"
Write Row hash "EmployeeInfo"."NewHires"
Exclusive Row hash "SampleDB"."pseudo table"
Exclusive Table "SampleDB"."SampleTable"