Using multiple dbspaces allows your 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 IQ and temporary data with the CREATE DBSPACE command.
When possible, allocate all dbspaces when you create a database.
If you add dbspaces later, 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.
