Choosing a catalog page size

You can select a page size for the catalog store 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 4KB, where the IQ store is on a UNIX raw partition and has an IQ PAGE SIZE of 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