PAGE SIZE Parameter Guidelines

Set the catalog store page size with the CREATE DATABASE PAGE SIZE option. The default and minimum value for this option is 4096 (4KB).

Example

The following statement creates a database with a catalog PAGE SIZE of 4096 bytes (4KB), where the IQ store is on a UNIX raw partition and has an IQ PAGE SIZE of 131072 bytes (128KB). By default, the IQ store size is the size of the raw partition and the temporary store is half that size. Because no path is specified for the temporary store, it is created in the same directory as the catalog store.

CREATE DATABASE 'company'
IQ PATH '/dev/rdsk/c2t6d0s3'
PAGE SIZE 4096
IQ PAGE SIZE 131072