Specifying the size of your database

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.

Table 5-3: Default and minimum sizes of IQ and Temporary Stores

IQ page size

Default size of IQ Store

Default size of Temporary Store

Minimum IQ Store size when specified explicitly

Minimum Temporary Store size when specified explicitly

65536

4096000

2048000

4MB

2MB

131072

8192000

4096000

8MB

4MB

262144

16384000

8192000

16MB

8MB

524288

32768000

16384000

32MB

16MB