To diagnose a locking issue in the database it may be useful to know the contents of the rows that are locked. You can view the locks currently held in the database using either the sa_locks system procedure, or using the Locks tab in Sybase Central. Both methods provide the information you need, including the connection holding the lock, lock duration, and lock type.
Due to the transient nature of locks in the database, the rows visible in Sybase Central, or returned by the sa_locks system procedure, may no longer exist by the time a query completes.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|