Dbspaces
Add, modify, view properties, or delete a dbspace.
Creating a Dbspace
Add a new dbspace to the database.
Deleting (Dropping) a Dbspace
Delete (drop) a dbspace from the database.
Preallocating Space for a Dbspace
Preallocate space for a catalog dbspace.
Generating Dbspace DDL Commands
Display the data description language SQL code for creating a dbspace. The SQL code can be a useful reference and training tool.
Changing a Dbspace to Read-Only
Change a dbspace to read-only mode.
Viewing or Modifying Dbspace Properties
View or change the name, mode, status, and striping properties of a dbspace.
Granting Dbspace CREATE Permission
Grant dbspace create permission to users and roles.
Revoking Dbspace CREATE Permission
Remove dbspace create permission from users and roles.
Dbspace Privilege Summary
A list of the system privileges and object permissions required to complete the various dbspace tasks.
Parent topic:
Administer and Monitor SAP Sybase IQ
Created May 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sybase.com