Sybase IQ data stores consist of one or more files. They can contain both user data and internal database structures used for startup, recovery, backup, and transaction management. Typically, an IQ database has the following stores:
db-name.db is the catalog dbspace containing the system tables and stored procedures describing the database and any standard Adaptive Server Anywhere database objects you add. It is known as the Catalog Store, and has the dbspace-name SYSTEM.
db-name.iq is the main data dbspace containing the IQ table data and indexes. It is known as the IQ Store, and has the dbspace-name IQ_SYSTEM_MAIN.
db-name.iqtmp is the initial temporary dbspace containing the temporary tables generated by certain queries. It is known as the IQ Temporary Store and has the dbspace-name IQ_SYSTEM_TEMP.
Multiplex users may also create an IQ Local Store on a query server. It behaves like the IQ Store with respect to only that query server, and shares buffer cache with the IQ Main Store. This optional store has no default extension, although many users choose .iqloc.
Any of these stores, and the log files, are possible areas of failure.
