Retrieves information about deadlocks from an internal buffer created by the database server.
sa_report_deadlocks( )
You must have EXECUTE privilege on the system procedure, as well as the the MONITOR system privilege.
| Column Name | Data Type | Description |
|---|---|---|
| snapshotId | BIGINT | The deadlock instance (all rows pertaining to a particular deadlock have the same ID). |
| snapshotAt | TIMESTAMP | The time when the deadlock occurred. |
| waiter | INT | The connection handle of the waiting connection. |
| who | VARCHAR(128) | The user ID associated with the connection that is waiting. |
| what | LONG VARCHAR |
The command being executed by the waiting connection. This information is only available if you have turned on capturing of the most recently-prepared SQL statement by specifying the -zl option on the database server command line. |
| object_id | UNSIGNED BIGINT | The object ID of the table containing the row. |
| record_id | BIGINT | The row ID for system tables. |
| owner | INT | The connection handle of the connection owning the lock being waited on. |
| is_victim | BIT | Identifies the rolled back transaction. |
| rollback_operation_count | UNSIGNED INT | The number of uncommitted operations that may be lost if the transaction rolls back. |
| iq_rid | UNSIGNED BIGINT | The row ID for IQ RLV enabled tables. |
| iq_txn_id | UNSIGNED BIGINT | The transaction id of the associated row. |
When the log_deadlocks option is set to On, the database server logs information about deadlocks in an internal buffer. You can view the information in the log using the sa_report_deadlocks system procedure.
None.