Dbspace statuses include: 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 changes only 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 adding, dropping, and renaming. 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.
