Turns internal disk striping on or off.
ON, OFF
ON
Can be set for the PUBLIC group only. Requires DBA permissions. Takes effect at the next checkpoint.
This option can force disk striping to be set or unset for performance reasons. In Sybase IQ, disk striping places data in each dbspace file segment in a round-robin fashion; for example, the first database page written goes to the first dbspace, the second page written goes to the next dbspace, and so on). If the dbspace is in read-only or relocate mode, it is skipped.
When this option is ON, the data is distributed in all dbspace segments, and the spaces tend to fill up together, evenly. When this option is OFF, the spaces tend to fill up in order, from the first to the last.
For more information about disk striping and performance, see Balancing I/O in Chapter 5, “Managing System Resources” in the Sybase IQ Performance and Tuning Guide.
