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.
See the section “Dbspace management example” for examples of using the dbspace SQL statements and stored procedures to create dbspaces with reserve space, modify the size of dbspaces, display information about dbspaces, relocate objects, and drop empty dbspaces.
