Dbspace statuses can be 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 Reference: Statements and Options > SQL Statements > CREATE DBSPACE Statement, Reference: Statements and Options > SQL Statements > DROP Statement, and Reference: Statements and Options > SQL Statements > ALTER DBSPACE Statement.
For multiplex dbspaces, see Using Sybase IQ Multiplex > Multiplex Transactions. To change the status of a dbspace in Sybase Control Center, see the Sybase Control Center for Sybase IQ online help in SCC or at http://sybooks.sybase.com/nav/summary.do?prod=10680.