Some statements
are restricted to nodes of certain roles.
Restricted statements include:
- Coordinator – tatements with a coordinator role restriction only run on a coordinator
node.
- Writer – statements with a writer role restriction run on a writer node or a
coordinator.
- None – statements with no role restriction run on any node in the multiplex.
Role Restricted Commands| Coordinator Role Restriction |
Writer Role Restriction |
|---|
- All CREATE/ALTER/DROP
DBSPACE commands operating on IQ main store
dbspaces
- BACKUP
DATABASE
- LOCK
TABLE
- sp_iqemptyfile
|
All DDL commands that affect objects in the IQ main
store dbspaces. This includes ALTER/DROP of:- Tables
- Single and multicolumn indexes
- Table constraints
|
Unlisted statements are unrestricted.