Data Storage

A DBA can determine which tables, indexes, and join indexes reside on a given dbspace, relocate objects to other dbspaces, and drop any dbspace after emptying it of data.

A DBA can also define the number of writes to each dbspace before the disk striping algorithm moves to the next stripe.

• Dbfile Attributes and Operations
  A dbfile has read-write or read-only status.
• Dbspace Attributes and Operations
  Dbspace statuses can be online, offline, or dynamically offline.
• Read-only and Read-write Dbspaces and Files
  A file is read-only when either the file status is read-only or the file status is read-write, but the owning dbspace status is read-only.
• 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 or the Sybase Central Create Dbspace wizard.
• Guidelines for Dropping a Dbspace
  Issue a DROP DBSPACE command to remove a database file.