Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 130 / 536

Working with databases
110
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.
Specifying an IQ
PATH
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.
Example
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