Role Restriction

Some statements are restricted to nodes of certain roles.

Restricted statements include:
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.