Setting Up a Sybase IQ Database

Creating an IQ database is part of a larger setup process that begins with installation and ends when your database is available to users.

1. Install and configure Sybase IQ.

   This step installs the client and server environment and the iqdemo database. See the Installation and Configuration Guide for your platform for details.

2. Create an IQ database.

   This step creates both the IQ store and the catalog store. You may use Sybase Central, the SQL statement CREATE DATABASE, or the iqinit utility.

3. Create the tables in your IQ database.

   Use the CREATE TABLE statement or the Sybase Central Create Table wizard.

4. Create indexes for the tables.

   Use the CREATE INDEX statement or the Sybase Central Create Index wizard. You can also create certain indexes automatically when you create your tables.

5. Load data into the tables.

   Use the LOAD TABLE statement to bulk load data from files, or use the INSERT statement to extract rows of data from an existing database.

• Guidelines for Scheduling Data Definition Tasks
  Once the database exists and other users have access to it, follow these guidelines when you need to perform additional data definition operations, such as adding or modifying tables or indexes.
• Dummy Tables for Performance Monitoring
  To start the IQ buffer cache monitor you must specify a permanent or temporary table, preferably a dummy table that you use only for monitoring.
• Authorities for Data Definition
  In order to perform data definition tasks, you must have the appropriate authority.
• Device Selection
  You store databases and database objects on devices. On all platforms, these devices can be operating system files. They can also be portions of a disk, called raw partitions. When you create a database, Sybase IQ determines automatically whether it is a raw partition or a disk file.
• Space Allocation
  All Sybase IQ databases are pre-allocated, whether they reside in a file system or a raw partition.