The required IQ PATH parameter tells SAP Sybase IQ that you are creating an SAP Sybase IQ database, not a SQL Anywhere database.
You specify the location of your IQ store in this parameter.
Choose a location for your database carefully. Although you can move an SAP Sybase IQ database or any of its files to another location, to do so, you must shut down the database and you may have to perform a backup and restore.
You can add space on a different drive, but you can only use this additional space for new data. You cannot readily move a particular index, table, or rows of data from one location to another.
Each operating system has its own format for raw device names. See Reference: Building Blocks, Tables, and Procedures > Physical Limitations for an important note about initializing raw devices on Sun Solaris.
Example | |
---|---|
AIX | /dev/rraw121v |
HP-UX | /dev/vg03/rrchee12g |
Sun Solaris | /dev/rsd0c |
Sun AMD | /dev/rdsk/c5t0d0s1 |
Device type | Name Format Required | SQL Example |
---|---|---|
Partitioned | Letter assigned to that partition | \\\\.\\C: |
Notpartitioned |
PhysicalDriveN, where N is a number starting with 0 and going as large as needed. You can find the physical drive numbers by running Disk Administrator in Administrative Tools. | \\\\.\\ PhysicalDrive32 |
On Windows systems, when you specify device names that include a backslash, you must double the backslash to keep the system from mistaking a backslash/letter combination for an escape sequence such as tab or newline command.
You must always double the backslash when naming raw devices on Windows in SQL statements.
The following statement creates a database called company.db. This database consists of four Windows files:
CREATE DATABASE 'company.db' IQ SIZE 200 IQ PATH 'c:\\company\\iqdata\\company.iq'
The following statement creates a database called company.db. This database consists of four UNIX files:
CREATE DATABASE 'company.db' IQ SIZE 2000 IQ PATH '/disk1/company/iqdata/company.iq'