Database Locks

  • A database lock is taken on the database that the operation is operating on. While a database is locked, no other operations can lock the same database.

  • A database lock can be taken concurrently with locks on other databases.

  • If a database lock is taken, it will block a workspace lock from being taken.

  • Any blocked operations will queue.

  • Example: Database a takes a shared lock to perform CREATE DATABASE. Database b takes a shared lock to perform BACKUP DATABASE concurrently.