Sybase IQ lets you alter dbspaces between read-write, read-only, and relocate modes. For details, see “Changing the mode of a dbspace”.
Sybase IQ creates dbspaces in read-write mode by default.
Sybase IQ always opens read-only dbspaces in read-only mode. The server startup switch -iqro causes the main or local store to be opened read-only, regardless of the status of the dbspaces in the main or local store. Sybase IQ opens read-only dbspaces with read-only access at the operating system level.
Sybase IQ 12.6 servers allowed dbspaces to be
placed in read-only mode, but IQ did not enforce this at the volume
or file system level. Sybase IQ 12.6 would not allocate from
a read-only dbspace and would not write to a read-only dbspace.
However, if the database store was opened in read-write mode, the
read-only dbspace is actually open read-write at the file system
level. This is the case for all stores open in read-write mode,
except the main store of a multiplex reader or the main store of
a database started with the -r (read-only) switch.
Sybase IQ designates dbspaces in relocate mode as read-only in the sense that IQ will no longer allocate space from, or write to, the dbspace. It also designates the dbspace as a data source for the sp_iqrelocate stored procedure, which moves data from relocate dbspaces to read-write dbspaces.
Backup and restore operations support WORM devices. For details, see “Backup and restore using read-only hardware”.
