Dbspace updates on multiplex
differ slightly from those on simplex databases.
In general, when updating shared dbspaces:
- Only the coordinator can manipulate
shared IQ dbspaces.
- Before you can drop a shared dbspace file, you must alter the file to read-
only mode. All servers must have advanced to the version corresponding to the ALTER READONLY statement, and must have returned all reserved blocks on the file.
- CREATE DBSPACE, ALTER DBSPACE and DROP DBSPACE commands
for main and catalog dbspaces are allowed only on the coordinator
- For IQ_SHARED_TEMP behavior, see Multiplex Transactions > DDL Commands > Role Restriction > Dbspace Updates in Multiplex > Updates on IQ_SHARED_TEMP.
Due to delays in TLV propagation and version maintenance, there may
be a delay of a few minutes before you can drop an
empty dbfile or dbspace. You see a Command not replayed error.
To perform the DROP
DBSPACE or ALTER DBSPACE DROP FILE commands, the OkToDrop column
reported by the sp_iqdbspace and sp_iqfile procedures
must indicate “Y.”