Sybase Central is a graphical management tool for Sybase products, which connects to and manages Sybase products running on any Sybase-supported platform. You can use Sybase Central to start a Sybase IQ server and to create the database.
Creating the sample database and database server
using Sybase Central
On Windows, click Start, point to Programs | Sybase | Adaptive Server IQ 12.6 | Sybase Central Java Edition.
To start Sybase Central on UNIX, enter the command
% scjview
In Sybase Central, click Sybase IQ, click the Utilities tab, and double-click Create Database.
A dialog box prompts you for the server options.
Click Next.
The next dialog box prompts you for the Connection Parameters.
Specify an appropriate user account with DBA authority and connection parameters for the server. These values represent the IQ system defaults:
Username – DBA
Password – SQL
Port Number – 2638
Host machine name identifies the machine where IQ is installed and where you want to create the database.
Click Next.
A dialog box prompts you for the name and location of the sample database and IQ files.
Specify a path and filename for the sample database, for example, <path>\RAPIQ.db
The Sybase IQ server and the IQ database must have identical names,
if you are using IQ as a target database for Replication Server.
This is a requirement of Replication Server.
This path should exist locally on the given host. If you omit the path, Sybase Central creates the database relative to the directory where the server was started.
Type a path and filename for the IQ Store, which contains the IQ data, for example, <path>\RAPIQ.iq
If your sample database is on disk, deselect the This is a raw device checkbox, then click Next.
On the next dialog box, enter an IQ Store Size of 2 GB (2000 MB) and accept the defaults for IQ_Page_Size and Database Page Size.
Click Next.
A dialog box prompts you for the temporary store path and size.
If you database is on disk, deselect This is a raw device.
This step creates a temp file that IQ uses as work space during processing. In the Specify the path for the temporary dbspace field, add the full path and file name you want to use. This file must have an .iqtmp extension. Specify 1000 (1 GB) for File Size in MB. Accept the defaults for all remaining parameters, check Skip to last page, then click Next.
On the Create Database - Summary screen, confirm your choices and click Finish to create the database.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
