Installing Sybase IQ Server Components

This section describes how to install the Sybase IQ Server Components.To install the Sybase IQ Client Components, see Chapter 2, “Installing Sybase IQ Network Client.”

To install Sybase IQ Server Components, run the installation program on the product CD. For UNIX systems, the program is called sybinstall.

By default, the program installs:

Sybase IQ 12.6
Sybase Central Java Edition viewer 4.3 (the graphical administration tool) and the latest plug-in for Sybase IQ. For details about using Sybase Central, see its online help or Introduction to Sybase IQ.
Software Developer’s Kit (SDK) version 12.5.1, which provides Open Client connections for ASE servers.
The Sybase jConnect JDBC Driver, version 5.5. The installation includes a recent EBF. If you install the jConnect driver, Java classes installed into a database can make JDBC calls to access and modify data. You need TCP/IP to use the jConnect driver.

The Sybase jConnect JDBC Driver version 6.0 is optionally available, but Sybase IQ requires jConnect 5.5 in order to work with Sybase Central and other java components. If you install jConnect 6.0 without installing 5.5, Sybase IQ functionality will be incomplete.
Java Runtime Environment 1.4.2.

You may deselect unneeded components before installing, except for Open Client, which is required.

WARNING! If you have an existing version of Open Client on your system, installing Open Client will add missing Open Client files and overwrite older files.

To install the Server Components, you must:

Mount the CD and set up the sybase account
Prepare the installation directory
Run the sybinstall utility
Set environment variables
Unmount the CD

The sections that follow describe each of these tasks.

Mounting the CD and setting up the sybase account

If your CD has been set up for auto-mount, you must get the absolute pathname for this device from the System Administrator. In this case, change directory to this specified directory and skip to the procedure titled “To prepare the installation directory” on the following page. Otherwise follow all the steps to load the Sybase IQ software from a CD.
Log on as the user “root”.
Place the CD into the CD drive.
Create a subdirectory of the root directory where you will mount the CD, if one does not already exist. For example:
```
% cd /
% mkdir /cdrom
```
If your system does not auto-mount, mount the CD with a command like the following:
```
% mount device_name /cdrom
```
where device_name is the name of the CD drive and /cdrom is the name of the directory where the CD will be mounted.
If there is no “sybase” account on your system, set one up to perform all unloading tasks. (Setting up this account requires “root” privileges.)

It is important to maintain consistent ownership and privileges for all files and directories. A single user with read, write, and execute permissions should perform all Sybase IQ unload, installation, upgrade, and setup tasks.

The “sybase” user must have permission privileges from the top (or root) of the disk partition or operating system directory down to the specific physical device or operating system file.
Log out as “root” and type “exit”.

Preparing the installation directory

Log on as the “sybase” user. This command logs into system storm:

% rlogin -l sybase storm

Identify or create a directory location for the Sybase installation directory, where you unload the Sybase IQ product. The “sybase” user should be the owner of the directory. If you have other Sybase products installed, Sybase recommends that you install Sybase IQ in its own separate directory, not the $SYBASE directory used by another product. To create a directory, use a command like the following:

% mkdir cd-install;chmod777 cd-install

Run the “disk free” command to verify that the directory location for the Sybase installation directory is in a UNIX file system with enough space to accommodate the software.
```
df -k .
```
Check the amount of free space against Table 1-2.
Set the SYBASE environment variable to the path of the installation directory you have chosen for Sybase IQ, using the following formats. In these examples, the SYBASE installation directory is /work/server
- For the tcsh or C (csh) shell, add this line to the .cshrc file:
```
setenv SYBASE /work/server
```
- For the bash or Korn (ksh) shell, add this line to the .profile file:
```
SYBASE=/work/server;
export SYBASE
```
Use the ls -la command to verify that you have permission to read, write and execute in the Sybase installation directory.

Running the sybinstall utility

Change directory to the installation directory:

% cd $SYBASE

Start the install utility, sybinstall. You can run this utility as series of menus with prompts or bypass menus using the sybinstall command line parameters.

**Table 1-4: Command parameters for sybinstall utility**
Parameter	Function
-autoinstall	Install all defaults.
-help	Display all parameters and usage.
-I_accept_sybase_license	Bypass license agreement prompt.
-info\|version	Display information about this product.
-y	Assume “yes” to all questions, warnings, and errors.

The following command runs sybinstall with all menus and prompts, so that you can choose the components installed.

% /cdrom/sybinstall

The following command runs sybinstall so that it installs the default products:

% /cdrom/sybinstall -autoinstall -I_accept_sybase_license

The installation procedure log is created in $SYBASE/sybinstall.log. If the file cannot be created in the $SYBASE directory, it defaults to /tmp/sybinstall.log.

The following steps show the menus that sybinstall displays by default.

To enter a response, type the desired letter or number, then press Return.

On the Welcome screen, press Return to continue.

If you have previously installed Sybase IQ 12, the script first displays information about servers currently running. This screen ends with the message:

The above IQ servers have been found running on this system. Please check that all Sybase IQ servers running in $SYBASE directory have been shut down before continuing. 

Do you want to continue <Y/N>?

Type “Y” or “N” depending on the status of the servers:

Type “Y” if servers are not running in the $SYBASE directory.
Type “N” to exit the install. Verify that the server or servers are shut down before you continue.

Type the number that corresponds to the location where you are installing.

If the country where you are located is not listed, select the most appropriate area (‘Americas (Mid/So.), Asia Pacific – General’, ‘Europe, Middle East, Africa – General’, or ‘Other Locations’).

The first screen of the License Agreement for your location displays.

If you don’t find a license agreement that matches your location, or if the license agreement is unreadable on your system, you can read all available license agreements at the Sybase website, and rerun sybinstall passing it the parameter -I_accept_sybase_license. For example:

%/cdrom/sybinstall -I_accept_sybase_license
Press Return to scroll through the agreement until you reach the end where a Y/N prompt displays.
Type “Y” to accept the license terms and continue the installation. If you disagree with the terms of the license and type “N”, the installation procedure quits.

The next script lists the amount of free space available in your $SYBASE directory, and the amount of space required for the six products it installs.
To accept the default, type “S”.

By default, all six products are installed. You must install Open Client 12.5.1 (or have it already installed) in order to start Sybase IQ.

If Adaptive Server Enterprise is on the same system as Sybase IQ, you must maintain the environment for each product separately and correctly.
To deselect or change any of the installed products, type the option number at the prompt.

For example, to deselect Sybase Central Java Edition, type “3”. Deselected products will not be installed.

You can only deselect one product per screen. The screen displays again with the words “Not Selected” under the Install directory for each deselected product. In this example, the installer has deselected Sybase Central Java Edition.

Numbers 1 through 6 are toggle options. If you change your mind, type the number of a deselected product to reselect it.
Check the Install Directory listed for each product to be installed. If the installation does not default to the desired directory, type “C” and type the target directory you prefer at the “Enter new target directory” prompt.
After selecting products, type “S” to start the installation.

Before installing files, sybinstall displays the Setup Utility Database screen. The utility database (utility_db) never holds data. It is used in special cases when the server needs a connected database but either no database exists or none should be running, for example, when restoring a database. Connecting to utility_db allows you only a narrow range of specialized file manipulation statements: CREATE DATABASE, DROP DATABASE, and RESTORE DATABASE. For more information, see “Utility database server security” in Sybase IQ System Administration Guide.

The ascii file that holds the login and password for this database is $ASIQ_DIR/bin/util_db.ini. By default, the login is “dba” and the password is “sql”. You can change the login and password by responding to the prompt:
```
Do you want to change the current user and password <Y/N>?
```
To change the login and password, type “Y”. The installation procedure prompts you for a new login and a password.
Type “N” if you do not want to change the default login or password.
As the procedure installs each product selected, it displays a list of the files installed. This may take a few minutes. When the installation completes, a message lists environment setup files created. After installing the required components, the install procedure may prompt for optional components or licenses: Do you have any components and licenses to enter at this time <Y/N>?


Type one of the following:


Type “Y” if you have
optional components to install. 

The installation procedure prompts you for the key, which
you type exactly as it appears on your installation key document. 

The following message will appear <Component>
enabled!


Type “N” if you have no optional
components to install. When the installation completes, a message
lists environment files that the setup created.



Setting environment variables


You must set certain environment variables to run
the Open Client Developer’s Kit, Sybase IQ, and/or
utility programs. Sybase IQ installs environment files that you
can run to set variables.

If you plan to run Open Client and Sybase IQ on the same
system, skip to Step 2.



To run Open Client Developer’s Kit on
a standalone system, perform this step.

bash or Korn (ksh) shell users type:


%. $SYBASE/SYBASE.sh


tcsh or C (csh) shell users type:


%source $SYBASE/SYBASE.csh



To run Sybase IQ, set environment variables by running
the environment file appropriate to your shell. 


Note that the environment files listed below also set
the variables needed to run Open Client and the variables needed
to run any of the administration utilities (dbisqlc, dbstop,
etc.).



bash or Korn (ksh) shell users type:


%source $SYBASE/ASIQ-12_6/ASIQ-12_6.sh


tcsh or C (csh) shell users type:


%source $SYBASE/ASIQ-12_6/ASIQ-12_6.csh





Completing the installation


Print
and read $ASDIR/readme.txt. 


Log on as the “root” user and unmount
the CD (if you had to mount to begin the installation):


% umount /cdrom



Remove the CD from the drive.


If
you installed Sybase Central, see the Sybase IQ System Administration Guide for
instructions on configuring and running the IQ Agent. You must configure
and run the IQ Agent in order to manage multiplex servers with Sybase
Central.


Log out.




To test Sybase IQ and read about the parameters required
to start the product, see “Running Sybase IQ”.

Finding the latest information on EBFs and software
updates


After installing the software, Sybase strongly recommends
that you check the online support Web site for software updates.
If a software update (EBF) has been released, it contains corrections
made after this product shipped.



Point your Web browser to the Sybase Support Page.


Select EBFs/Maintenance. Enter user name and
password information, if prompted (for existing Web accounts) or
create a new account (a free service).


Select a product.


Specify a time frame and click Go.


Click the Info icon to display the EBF/Maintenance
report, or click the product description to download the software.












Copyright © 2005. Sybase Inc. All rights reserved.








View this document as PDF