Although there are several ways to start a Sybase IQ server and connect to a database, these procedures give you some simple ways to get started.
Starting the sample IQ database from the command
line
On the system where you created the Sybase IQ database, start the IQ server with the sample database.
For example, to start the server from the command line using the edited configuration file, change directory to the directory containing the .cfg and .db files and enter:
start_asiq @RAP_RAPIQ.cfg RAP_RAPIQ.db
Be sure to use the -n switch to name the server, either in the configuration file, or on the command line when you start the server.
Connect to the sample IQ database with the user ID DBA and password SQL.
For example, to connect using Interactive SQL from the machine where the Sybase IQ server RAPIQ and the database RAPIQ are running, you can enter on the command line:
dbisql -c "uid=DBA;pwd=SQL;eng=RAPIQ_RAPIQ;
dbn=RAP_RAPIQ;dbf=RAP_RAPIQ.db;
links=tcpip{port=2638;host=IQ_server}"
Starting the sample IQ database from Sybase Central
In Windows, you can also use Sybase Central to start the server and connect to the sample database.
Click Start, point to Programs | Sybase | Adaptive Server IQ 12.6 | Sybase Central Java Edition.
In Sybase Central, click Sybase IQ, click the Utilities tab, and double-click Start Server.
A dialog box prompts you for the start-up options.
Select Single server and click Next.
On the Connection Parameters dialog, type the appropriate connection parameters. See the following table for system defaults.
Field name... |
Value |
|---|---|
Server Name |
server_name |
Host machine |
host_name |
Port number |
port_number |
Database Name |
database_name |
Username |
DBA |
Password |
SQL |
Click Next.
Specify the full path to the database file, then click Next.
Click Finish to start the server.
Other startup and connection options
If you are a UNIX user, see the Sybase IQ Installation
and Configuration Guide for more information.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
