In Sybase IQ 15.0, dbspace management and range table partitions:
Provide data placement capability
Provide hierarchical storage management by supporting relocation of less critical data to cheaper storage
Dbspace management and range table partitions improve maintainability and availability by:
Supporting dbspace read-only (RO) vs. read-write (RW) status
Supporting dbspace online vs. offline status
Shortening backup/restore by allowing backing up or restoring one or more RO dbspaces and/or files, or all RW files
Supporting data validation on a dbspace or a table partition target. See “sp_iqcheckdb procedure” in Chapter 7, “System Procedures,” in Reference: Building Blocks, Tables, and Procedures.
Allowing Sybase IQ servers to start with unavailable and/or non-usable dbspaces marked “offline” except for the catalog store and the Sybase IQ system dbspace.
