Sybase Central is a graphical management tool for Sybase products and plug-ins. Sybase Central includes a database creation utility you can use to start the server and create the database.
Start Sybase Central.
On Windows, click Start, point to Programs | Sybase | Adaptive Server IQ 12.6 | Sybase Central Java Edition.
If you use Sybase Central on the UNIX Platform, first set the DISPLAY variable. The command you use depends on your shell:
Shell... |
Command... |
|---|---|
C-shell |
setenv DISPLAY <terminal host name>:0.0 |
B-shell |
export DISPLAY=<terminal host name>:0.0 |
To start Sybase Central on UNIX, source the ASIQ-12_6.sh (or .csh) script in the $SYBASE/ASIQ-12_6 directory, then enter this command:
% scjview
Click Sybase IQ | Utilities tab | 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. See the table below for IQ system defaults.
Parameter |
Value |
|---|---|
Username |
DBA |
Password |
SQL |
Port Number |
2638 |
Host machine name |
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 IQ files.
Specify an appropriate path and filename for the RAP repository 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.
For more information, see Appendix B, “Data Replication.”
This path should exist locally on the given host. If you omit the path, Sybase Central creates the database relative to the directory where you started the server.
Type a path and filename for the IQ Store, which contains the IQ data, for example, <path>\RAPIQ.iq
If your RAP repository database is on an operating system file system, 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 your database is on an operating system file system, deselect This is a raw device.
Deselecting this option creates a temp file IQ uses as work space during processing. Add the full path and file name for the temporary dbspace file 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, and click Next until you reach the Default Database Attributes page.
On the Default Database Attributes page, click the Emulate as ASE button. Accept the remaining defaults, and click Next until you reach the summary screen.
On the summary screen, review your choices, click Finish.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
