Sybase IQ ETL Development client is currently available only on Windows systems. Sybase IQ Network Client is available on both Linux and Windows.
Sybase IQ Network Client for Linux contains the components required for connection to a network server.The 32-bit client is compatible with IQ servers on all supported server platforms; there is no 64-bit client.
Sybase IQ Network Client for Linux is certified to run on:
Red Hat Enterprise Linux 3.0 i86 or AMD64, Advanced Server or Workstation Edition:
kernel 2.4.21-27.0.2.ELsmp #1 SMP and glibc 2.3.2-95.30 on 32-bit systems
kernel 2.4.21-27.0.2.ELhugemem #1 SMP and glibc 2.3.2-95.30 on 64-bit systems
Red Hat Enterprise Linux 2.1 x86, Advanced Server or Workstation, with kernel 2.4.9-e.40smp and glibc 2.2.4-32.8.
SuSE Linux Enterprise Server (SLES) 8.0, kernel 2.4.9-e.57smp #1 SMP and glibc 2.2.4.-32.18
SuSE Linux Enterprise Server (SLES) 9.0 for 32-bit systems, kernel 2.6.5-7.97-smp #1 SMP and glibc 2.3.3-98.28
Sybase IQ Network Client is also compatible with Red Flag Linux DB Server release 4.0, kernel 2.4.21-AS.2 smp on i686 and glibc 2.2.93.
Sybase IQ Network Client does not run on IBM Linux on POWER.
Table 3-1 demonstrates that you can run different versions of Sybase IQ on the same system.
Product and version to install |
Product and version already installed |
Compatibility |
---|---|---|
12.7 Server |
12.5 Server |
Standalone IQ Agent only |
12.5 Network Client |
Allowed, provided that environment for each is set up for the appropriate version |
|
12.6 Network Client |
Allowed as an upgrade |
|
12.7 Network Client |
12.5 Server |
Allowed, provided that environment for each is set up for the appropriate version |
12.5 Network Client |
Allowed. If one is uninstalled, user must repair remaining one. |
|
12.6 Server |
Prohibited |
Table 3-2 lists disk space required to install Sybase IQ Network Client for Linux.
Product |
Disk space |
---|---|
Sybase IQ 12.7 Network Client |
275MB |
Sybase Central Java Edition 4.3 |
4MB |
jConnect 5.5 |
17MB |
jConnect 6.0 |
6MB |
Java Runtime Environment 1.4.2 |
60MB |
The following procedures describe how to install the Sybase IQ Network Client for Linux. To install other Sybase IQ products or components, see the following sections:
To install the Sybase IQ Network Client for Windows, see “Installing client components on Windows.”
To install Sybase IQ ETL Development (client components with data extraction, transformation, and load capabililty) see “Installing Sybase IQ ETL Development”.
To install the Sybase IQ Server Components, see Chapter 2, “Installing Sybase IQ.”
Mounting the product 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 -o -ro -F hsfs 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 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. To create a directory, use a command like the following:
% 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 Table 3-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) C 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
If this is the first Sybase product you have installed, see “Mounting the product CD and setting up the sybase account”and “Preparing the installation directory”.
Change directory to the installation directory:
% cd $SYBASE
Start the install utility, sybinstall. You can run this utility as a series of menus with prompts, or bypass menus using the sybinstall command line parameters.
Parameter |
Function |
---|---|
-add_agent |
Install standalone 12.7 IQ Agent only |
-autoinstall |
Install all defaults |
-help |
Display all parameters and usage |
-I_accept_sybase_license |
Bypass license agreement prompt when using -autoinstall |
-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
.
Avoid installing Sybase IQ Network Client in the same directory as an IQ server. If you attempt to do this, an error like the following displays:
WARNING The directory ‘/olddev1/users/sybase_scr/ASIQ-12_7’ contains files for the ASIQ server. This install contains only the network client files and should never be installed in the same directory as an existing server. Please make sure that /remote/ase/linux is set to the correct directory Do you want to continue <Y/N>?
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.
Type the number that corresponds to the location where you are installing.
If you find no 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 Web site, and rerun sybinstall, passing it the parameter -I_accept_sybase_license. For example:
% /cdrom/sybinstall -I_accept_sybase_license
The first screen of the Software Test and Evaluation License Agreement displays.
As you read, hold down the Return key until you reach the end of the agreement.
At the end of the agreement, a prompt appears.
Type “Y” to accept the license terms and continue the installation. If you disagree with the terms of the license, type “N.”
The script next lists the amount of space available in your $SYBASE directory, and the amount of space required for the three components it installs.
To install all four products, type “S.” 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 “2.”
Deselected products are not installed. You can deselect only one product per screen. When you deselect a product, the screen displays again with the words “Not Selected” under the Install directory for that product.
Numbers 1 through 4 are toggle options. If you change your mind, type the number of a deselected product to reselect it.
After selecting products, type “S” to start the installation.
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.
You must set certain environment variables to run Sybase IQ. Sybase IQ installs environment files that you can run to set variables.
bash or Korn (ksh) shell users should type:
% source $SYBASE/ASIQ-12_7/ASIQ-12_7.sh
tcsh or C (csh) shell users should type:
% source $SYBASE/ASIQ-12_7/ASIQ-12_7.csh