Tools for Managing Locks

While locking and unlocking occurs automatically, Sybase IQ helps you manage locks by means of stored procedures, the IQ monitor, and database and server options.

• Displaying Active Locks
  An attempt to write to a table fails if another transaction holds a lock on that table.
• Tools for Investigating Lock Contention
  Some load or query performance issues result from lock contention.