Defines the number of kilobytes (KB) to write to each dbspace before the disk striping algorithm moves to the next stripe for the IQ Main Store.
Integer greater than zero, in kilobytes
1 (which rounds up to one page)
Can be set only for the PUBLIC group. Requires DBA permissions to set the option. Takes effect at the next checkpoint.
MAIN_KB_PER_STRIPE lets you control the number of kilobytes written to each dbspace before the IQ disk striping algorithm moves to the next stripe for the IQ Main Store. The corresponding number of blocks is rounded up to a page boundary, so the actual amount written to each stripe might be slightly larger than requested. You can tune this option by measuring the time required to complete I/O intensive updates and adjusting the option value accordingly.
Chapter 5, “Working with Database Objects” in the Sybase IQ System Administration Guide.
“Balancing I/O” on page 135 in Chapter 5, “Managing System Resources” in the Sybase IQ Performance and Tuning Guide.
