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.

Related concepts
Dbspace Management Example
Disk Space
Locks for DDL Operations
Versioning of Temporary Tables
Related tasks
Disconnecting All Connections from a Database in Interactive SQL