When you are connected to a database in Sybase Central, you can see a diagram of any deadlocks that have occurred in the database since the log_deadlocks option was set to On.
To use Sybase Central deadlock reporting
Select the database in the left pane of Sybase Central, and then choose File » Options.
The Database Options window appears.
Turn on the log_deadlocks option.
The database server records information about deadlocks in an internal buffer.
For more information, see log_deadlocks option [database].
Click the Deadlocks tab in the right pane.
A deadlock diagram appears if there are any deadlocks in the database.
Each node in the deadlock diagram represents a connection and gives details about which connection was deadlocked, the user name, and the SQL statement the connection was trying to execute when the deadlock occurred. There are two types of deadlocks: connection deadlocks and thread deadlocks. Connection deadlocks are characterized by a circular dependency for the nodes. A thread deadlock is indicated by nodes that are not connected in a circular dependency, and the number of nodes is equal to the thread limit on the database plus one.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |