Defines the number of kilobytes (KB) to write to each dbspace before the disk striping algorithm moves to the next stripe for the IQ Temporary Store.
Integer greater than zero, in kilobytes
1 (which rounds up to one page)
Can be set only for the PUBLIC group. DBA authority is required to set the option. Takes effect at the next checkpoint.
TEMP_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 Temporary 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 in Chapter 5, “Managing System Resources,” in the Sybase IQ Performance and Tuning Guide.
