Dbspace management has been enhanced to allow users to move IQ data off of disks and take the disks offline without any downtime. Key features include:
Any dbspace can be dropped
Improved disk striping
Read-only Main dbspaces
Dbspaces can be resized
New stored procedures, new database options, and SQL statements provide the interface to determine where objects reside and to relocate objects within the resource constraints of the database. For more information, see the appropriate chapters in the Sybase IQ Reference Manual.
New stored procedures: sp_iqindexinfo, sp_iqdbspaceinfo, sp_iqrelocate, sp_iqdbspace in Chapter 9, “System Procedures”
New database options: MAIN_KB_PER_STRIPE, TEMP_KB_PER_STRIPE in Chapter 2, “Database Options”
New SQL statement: ALTER DBSPACE in Chapter 6, “SQL Statements”
Changed SQL statements: CREATE DBSPACE, CREATE DATABASE, DROP (DBSPACE) in Chapter 6, “SQL Statements”
See also Chapter 5, “Working with Database Objects” in the Sybase IQ System Administration Guide.
