When you create a database, the database server creates certain dbspaces automatically.
Dbspace Name | Purpose | Default Operating System File Name |
---|---|---|
IQ_SYSTEM_MAIN | Main (permanent) IQ store file | dbname.iq |
IQ_SYSTEM_MSG | Message log file | dbname.iqmsg |
IQ_SYSTEM_TEMP | Temporary IQ store file | dbname.iqtmp |
IQ_SHARED_TEMP | Temporary IQ store | Initially, this dbspace contains no files. |
SYSTEM | Catalog store file | dbname.db |
The SYSTEM dbspace contains the system tables, which hold the schema definition as you build your database. It also holds a separate checkpoint log, rollback log, and optionally a write file, transaction log, and transaction log mirror, for the catalog store.