Sybase 12.4.2 manual 110

Working with databases

Specifying an IQ PATH

Example

If you omit the directory path, Adaptive Server IQ locates 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 IQ Store, unless it is on a raw device. (This also occurs if you do not specify any file name.)

•The Message Log is created in the same directory as the IQ Store, unless it is on a raw device. (This also occurs if you do not specify any file name.) The Message Log cannot be on a raw partition.

•The Transaction Log is created in the same directory as the Catalog Store. (This also occurs if you do not specify any file name.) However, you should place it on a different physical device from the Catalog Store and IQ Store, on the same physical machine.

Note You must start the database server from the directory where the database is located, for any database created with a relative pathname.

The required IQ PATH parameter tells Adaptive Server IQ that you are creating an IQ database, not an Anywhere database. You specify the location of your IQ Store in this parameter. It is preferable to use a relative pathname. When you do, the IQ Store is created relative to the directory where the server was started, which can change the next time the server is started.

Choose a location for your database carefully. Although you can move an IQ database or any of its files to another location, to do so you must restore the entire database. A full restore is a time-consuming process, during which users cannot be connected to the database.

You can add space on a different drive, as described in “Adding dbspaces” but you can only use this additional space for new data. You cannot readily move a particular table, index, or rows of data from one location to another. You would need to drop the table or index, recreate it, and reload it; or you would need to delete those rows, and reinsert them.

The following statement creates an IQ database called company.db. This database consists of four NT files:

•The Catalog Store is in company.db, in the directory where the server was started (in this case, c:\company)

•The IQ Store is in c:\company\iqdata\company.iq

110