Using multiple dbspaces allows your Sybase IQ and temporary data to be broken down into multiple operating system files or partitions. These files can then be spread across multiple disks.
Like disk striping, randomness can be created by placing successive database files across multiple drives. You can create additional segments for your Sybase IQ and temporary data with the CREATE DBSPACE command.
When possible, allocate all dbspaces when you create a database.
If you add dbspaces later, Sybase IQ stripes new data across both old and new dbspaces. Striping may even out, or it may remain unbalanced, depending on the type of updates you have. The number of pages that are “turned over” due to versioning has a major impact on whether striping is rebalanced.
