Database Size Guidelines

When you create a database, you set the size and reserve size in MB of the initial IQ database file (the IQ_SYSTEM_MAIN dbspace).

These values are defined in the IQ SIZE and IQ RESERVE parameters for the main store and TEMPORARY SIZE and TEMPORARY RESERVE for the temporary store.

For raw partitions, you do not need to specify IQ SIZE or TEMPORARY SIZE; SAP Sybase IQ determines the size of the raw devices and sets IQ SIZE and TEMPORARY SIZE automatically. If you do specify size, the size cannot be larger than the actual raw partition size.
For operating system files you can rely on the defaults or specify a value based on the size of your data, from the required minimums up to a maximum of 4TB, in 1MB increments.

Default and Minimum Sizes of IQ and Temporary Stores
The IQ RESERVE and TEMPORARY RESERVE parameters reserve a range of blocks, so that the dbspace can be resized at a later time. Making IQ RESERVE larger than needed can use additional disk space, however.

Parent topic: Database Creation with SQL