Sybase IQ database files

When you create a database, Sybase IQ creates a number of files.

**Table 2-1: Database files**
Physical file name	Internal name	Description	Number created
dbname.db	Not applicable	Anywhere dbspace file. Part of the Catalog Store.	One or more per server
dbname.log	Not applicable	Anywhere transaction log. Part of the Catalog Store.	One per server
dbname.iq	IQ_SYSTEM_MAIN	IQ dbspace file for the main IQ Store. (User specifies the names for additional files).	One or more per database
dbname.iqtmp	IQ_SYSTEM_TEMP	IQ temporary dbspace file.	One or more per database
dbname.iqloc	IQ_LOCAL	IQ dbspace file for main IQ stores local to a particular query server. This file is not created automatically.	Optionally, one or more per query server. Multiplex databases only.
dbname.iqmsg	IQ_SYSTEM_MSG	IQ human-readable trace file of debugging output.	One per database
Note: The DBA can override the default file names and extensions shown.

You can create a database using a relative or fully qualified pathname for each of the files for the database. If you omit the directory path, Sybase IQ creates the files as follows:

The Catalog Store is created relative to the working directory of the server.
The IQ Store is created relative to the working directory of the server.
The Temporary Store is created in the same directory as the Catalog Store. (This also occurs if you do not specify any file name.)
The Message Log is created in the same directory as the Catalog Store. (This also occurs if you do not specify any file name.)
The Transaction Log is created in the same directory as the Catalog Store. (This also occurs if you do not specify any file name.)

For best performance, you should place the Transaction Log on a different physical device from the Catalog Store and IQ Store, because they are randomly accessed files and the transaction log is a sequentially accessed file.

The Main and Temp stores contain most of your tabular data. Each database has its own unique files for temporary data. If you don't specify a file, Sybase IQ creates one automatically for use as a temporary storage space. For details about creating a temporary storage area, and what happens if the storage area defined is insufficient, see Sybase IQ Installation and Configuration Guide.

Sybase IQ includes a sample database named asiqdemo. The files that comprise the database are located in the demo subdirectory of your installation directory.