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.

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