DEFAULT_KB_PER_STRIPE Option

Sets an upper threshold in KB on the amount to write to a stripe before write operations move on to the next stripe.

This setting is the default size for all dbspaces in the IQ main store.

Allowed Values

1 to maximum integer

Default

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

Remarks

The default value of 1KB means that one page is compressed and that the compressed page is written to disk as a single operation. Whatever the chosen page size, the next operation writes to the next dbfile in that dbspace.

To write multiple pages to the same stripe before moving to the next stripe, change the DEFAULT_KB_PER_STRIPE setting. For example, if the page size is 128KB, and DEFAULT_KB_PER_STRIPE set to 512KB, SAP IQ queues up page writes and writes to disk after reaching the minimum of 512KB of compressed pages.

This option is used only by CREATE DBSPACE and defines the default disk striping size for dbspaces in the IQ main store, if CREATE DBSPACE does not specify a stripe size.