IQ_SYSTEM_MAIN Dbspace

IQ_SYSTEM_MAIN is a special dbspace that contains structures necessary for the database to open: the IQ checkpoint log, IQ rollforward/rollback data for each committed transaction and each active checkpointed transaction, the incremental backup metadata, and database space and identity metadata.

The IQ_SYSTEM_MAIN dbspace is created at database creation or when you upgrade an older IQ database to Sybase IQ 15.4. IQ_SYSTEM_MAIN is always online when the database is open.

Related concepts
Insufficient Disk Space
IQ Main Store and IQ Temporary Store Space Management
Load Performance During Database Definition
Main IQ Store Blocks Message
Monitoring Disk Space Usage
Processing Issues
Sizing Guidelines for Main and Temporary Stores
Sybase IQ Stops Processing or Stops Responding