Setting Database Page Size Values

When the shared IQ Store is on a raw partition, the IQ Store Size box disappears because Sybase IQ determines the size of the raw device and sets IQ SIZE to that value. The Database Page Sizes screen would appear as follows:

When the IQ Store is a file, a screen like the following displays. Type the IQ Store size in MB in the space provided. The default is 1000, but for this tutorial, use 10MB.

For this tutorial, leave the Reserve size blank. In general, the amount of Reserve space you allow depends on how much space your hardware supports. If the dbspace partition is a single disk, you should never need more reserve than the largest disk currently available. If the partition is on a disk array, the size of a single partition could be much large, since a disk array can have a single partition that uses many disks.

Accept the IQ page size supplied, or choose one from the dropdown box. The Create Database wizard supplies an appropriate default page size in the IQ Page Size box. In general, the IQ page size determines the I/O transfer block size.

See the Sybase IQ System Administration Guide for more information. For this example, click Next to accept the default IQ page size (128KB).

Select a Database Page Size for the Catalog Store. (The Catalog Store holds the metadata for Sybase IQ.) The default is 4096 bytes (4KB). Sybase recommends that you use this default.

Click Next.