Dbspaces
Add, modify, view properties, or delete a dbspace.
Creating a Dbspace
Add a new dbspace to the database.
Deleting 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. Not applicable to cache dbspaces.
Revoking Dbspace CREATE Permission
Remove dbspace create permission from users and roles. Not applicable to cache dbspaces.
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 November 21, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com