Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_remove_tracing_data system procedure Next Page

sa_report_deadlocks system procedure

Retrieves information about deadlocks from an internal buffer created by the database server.


sa_report_deadlocks( )

Result set
Column nameData typeDescription
snapshotIdbigintThe deadlock instance (all rows pertaining to a particular deadlock have the same ID).
snapshotAtTIMESTAMPThe time when the deadlock occurred.
waiterINTThe connection handle of the waiting connection.
whoVARCHAR(128)The user ID associated with the connection that is waiting.

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 or have turned this feature on using the sa_server_option system procedure.

wait_onbigintThe name of the lock being waited on.
ownerINTThe connection handle of the connection owning the lock being waited on.

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.


DBA authority required

Side effects


See also