Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.
Certain operations will take either a database lock or a cluster lock. This topic explains what these locks are, their impact, and the operations that use them.
atakes a shared lock to perform
CREATE DATABASE. Database
btakes a shared lock to perform
ADD LEAFis running on the cluster. While the operation is running,
CREATE TABLEtries to run, but is blocked until
The following operations take database locks:
OPTIMIZE TABLE(for rowstore tables only)
The following operations take cluster locks:
AGGREGATOR SET AS MASTER
ATTACH LEAF ALL
CHECK BLOB CHECKSUM
CLEAR ORPHAN DATABASES
REBALANCE ALL DATABASES