This section describes how to install the Sybase IQ Server Components. To install components required for connection to a network server, see Chapter 2, “Installing Sybase IQ Network Client.”
If you have a previous 12.x version of Sybase IQ, you need to upgrade your databases as part of installation. See “Upgrading servers and databases to 12.6” and “Upgrading 12.4.3 multiplex databases to 12.6” for important steps you must complete before installing.
To install Sybase IQ, 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.
WARNING! If you have an existing version of Open Client on your system, installing the Open Client libraries 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.
To mount the CD and set
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 section titled “To prepare the installation directory” on the following page. Otherwise follow all the steps below 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 -o ro 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”.
To prepare 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 install 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.
% mkdir cd-install;chmod 777 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 “System requirements”.
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 C shell (csh), add this line to the .cshrc file:
setenv SYBASE /work/server
For the Korn (ksh) or Bourne (sh) 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.
To run 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.
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.
To enter a response on a sybinstall screen, type the desired letter or number and press Return.
On the Welcome screen, press Return to continue.
If you have previously installed Sybase IQ 12, the script displays information about any servers currently running. This screen ends with the message:
The above IQ servers have been found running on this system. Please check that all IQ servers running in $SYBASE directory have been shut down before continuing. Do you want to continue <Y/N>?
If any of the listed servers are running in the $SYBASE directory, exit the install and make sure the server(s) are shut down before you continue. If the servers are not running in the $SYBASE directory, enter “Y.”
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’, ‘Europe, Middle East, Africa’, or ‘Other Locations’).
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
The first screen of the License Agreement for your location displays. As you read, hold down the Return key to scroll until you reach the end of the agreement.
When you have read the complete agreement, you will see a prompt. To accept the license terms and continue the installation, enter “Y.” If you disagree with the terms of the license, enter “N,” which exits the installation procedure.
The script next lists the amount of free space available in your $SYBASE directory, and the amount of space required for the products it installs.
To accept the default, enter “S.”
By default, all six products are installed. You must install SDK (Open Client) 12.5.1 (or have it already installed) in order to start Sybase IQ.
To deselect or change any of the installed products, type the option number at the prompt. For example, to deselect Sybase Central Java Edition, enter “3.” Deselected product(s) will not be installed.
If Adaptive Server Enterprise is on the same system as Sybase IQ, you must maintain the environment for each product separately and correctly.
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.
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, enter “C” and
type the target directory you prefer at the Enter
new target directory prompt.
After selecting products, enter “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 $ASDIR/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 default user/password now <Y/N>?
To change the login and password, type “Y”. The installation procedure prompts you for a new login, then a password. If you do not wish to change the default login or password, type “N”.
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 prompts for optional components or licenses:
Do you have any components and licenses to enter at the time <Y/N>?
If you do, enter “Y”. The installation
procedure prompts you for the key. Type the installation key exactly
as it appears on your installation key document. Entering the key
returns the message <Component> enabled!.
If you have no optional components, enter “N”. When the installation completes, a message lists environment setup files created.
You must set certain environment variables to run the Open Client Developers Kit and Sybase IQ. 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 Developers Kit on a standalone system, perform this step.
Bourne shell users should enter:
%. $SYBASE/OCS-12_5/OCS-12_5.sh
C shell users should enter:
%source $SYBASE/OCS-12_5/OCS-12_5.csh
The environment files that set Sybase IQ variables also set the variables needed by Open Client.
Bourne shell users should enter:
%source $SYBASE/ASIQ-12_6/ASIQ-12_6.sh
C shell users should enter this command:
%source $SYBASE/ASIQ-12_6/ASIQ-12_6.csh
Print and read $ASDIR/readme.txt.
Log in as the “root” user and unmount the CD:
% 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 databases with Sybase Central.
Do not discard this document after installing Sybase IQ. “Starting the server” lists required
parameters for starting the product.
Log out.
To test Sybase IQ, see “Running Sybase IQ”.
After installing the software, Sybase strongly recommends
that you check the online support Web site for software updates.
If a software update (ESD or EBF) has been released, it contains
bug fixes made after this product shipped.
Finding the latest information on EBFs and software
updates
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.
