A dbspace may have three types of online status: online, offline, or dynamically offline. Dynamically offline means that the dbspace is marked offline in memory, as opposed to marked offline in the catalog. If a database starts and one or more dbfiles cannot be opened, the database starts but the dbspace is marked dynamically offline.An administrator can use ALTER DBSPACE ONLINE to bring a dbspace back online after fixing a problem, but this only changes the dbspace’s in-memory status.
In addition to online, offline, or dynamically offline status, a dbspace also has read-write or read-only status. When created, a dbspace is online and read-write.
A dbspace also has striping attributes. An administrator may specify whether striping is on and the stripe size.
Operations that can be performed on dbspaces include add, drop, and rename. See ALTER DBSPACE statement, CREATE DBSPACE statement and DROP statement in Chapter 1, “SQL Statements,” Reference: Statements and Options. For multiplex dbspaces, see “Updating dbspaces in multiplex” in Chapter 3, “Running Multiplex Transactions,” in Using Sybase IQ Multiplex.
