Viewing deadlocks from Sybase Central

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. Deadlock information is recorded in an internal buffer.

 Use Sybase Central deadlock reporting

  1. Select the database in the left pane of Sybase Central, and then click File » Options.

  2. Turn on the log_deadlocks option.

    1. In the Options list, click log_deadlocks.

    2. In the Value field, click On.

    3. Click Set Permanent Now.

    4. Click Close.

  3. In the right pane, click the Deadlocks tab.

    A deadlock diagram appears if there are 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.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1