Administration Workflow

Creating an SAP® Sybase® 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 SAP Sybase IQ.

   Install both the client and server environments. See the Installation and Configuration Guide guide.

2. Start and connect to a database server.

   Enable database control and open a communication channel to the database. Use the start_iq utility, Sybase Control Center, the Windows Start menu, or a configuration file.

3. Create an IQ database.

   Create both the IQ store and the catalog store. You may use Sybase Control Center, the SQL statement CREATE DATABASE, or the iqinit utility.

4. Create the tables in your IQ database.

   Use the CREATE TABLE statement or the Sybase Control Center Create Table wizard.

5. Create indexes for the tables.

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

6. 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. See Administration: Load Managementt.

• Guidelines for Scheduling Data Definition Tasks
  Once the database exists and other users have access to it, you must perform additional data definition operations, such as adding or modifying tables or indexes.
• System Privileges for Data Definition
  You must have the appropriate system privileges to perform data definition tasks.
• Device Selection
  Store databases and database objects on devices. On all platforms, these devices can be operating system files, or they can be portions of a disk, called raw partitions. When you create a database, SAP Sybase IQ determines automatically whether it is a raw partition or a disk file.