IQ Main Store (for data)

The IQ store holds all the user data (indexes) for the database compressed on disk.

It contains the transaction log for data in the IQ tables and structure to manage space allocation (free list). The internal transaction log manages transactions involving IQ data. The free list tracks page usage with a given dbspace.

The IQ store is a pre-allocated space (although it can be enlarged with advance planning). Initially, the IQ store has one file or raw device when the database is created, but additional files may be added to the IQ store as needed.

There is one IQ store per database, which usually consists of many files or raw partitions. When using raw partitions, the physical name will be the partition name. If setting up IQ multiplex on multiple hosts, the IQ store must be created using raw partitions.

The IQ main store consists of least two dbspaces:

IQ_SYSTEM_MAIN – The first dbspace created when creating a database, it contains system metadata. It should not be used for user data
USER_DBSPACE – Created and named by DBA, it holds user tables and indexes. DBAs may create additional dbspaces, as needed. The database option Default_Dbspace controls where tables and indexes are stored.