Dbspace Attributes and Operations

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.

Note: Table data is inaccessible if any indexes, data, or partitions exist in an offline dbspace.

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.

You can create, alter, or drop dbspaces.

For multiplex dbspaces, see Administration: Multiplex. To change the status of a dbspace in Sybase Control Center, see the Sybase Control Center for SAP Sybase IQ online help in SCC or at http://sybooks.sybase.com/sybooks/sybooks.xhtml?prodID=10680.

Dbspace Renaming Guidelines
You can rename a dbspace or dbfile name, but you cannot rename or drop catalog dbspace SYSTEM, IQ main dbspace IQ_SYSTEM_MAIN, IQ temporary dbspace IQ_SYSTEM_TEMP, shared temporary dbspace IQ_SHARED_TEMP, and IQ message dbspace IQ_SYSTEM_MSG.
Additional Dbspaces
Create a dbspace using the CREATE DBSPACE statement.
Guidelines for Dropping a Dbspace
Issue a DROP DBSPACE command to remove a database file.

Parent topic: Data Storage