For supported platform and operating system configurations and required patches, see the Sybase IQ Release Bulletin.
To install Sybase IQ Server Components, run the installation program on the product CD. For UNIX systems, the program is called sybinstall.
The installation program installs:
Sybase IQ Server 12.7
Sybase IQ ETL Server 4.2.1. You may optionally install this if you have the Sybase IQ Extended Enterprise Edition.
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.
Software Developer’s Kit (SDK) which provides native Sybase Open Client connectivity for Sybase clients and 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 SDK (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.
If you have a previous 12.x version of Sybase IQ, you need to upgrade your databases as part of installation. See “Upgrading non-multiplex databases” for important steps you must complete before installing.
To install the Server Components, you must:
Mount the product CD and set up the sybase account.
Prepare the installation directory.
Run the sybinstall utility from the Sybase IQ product CD (Extended Enterprise Edition, Developer’s Edition, or Enterprise Edition).
Set environment variables. (Sybase IQ Server installation only.)
Unmount the CD.
The sections that follow describe each of these tasks.
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 “Preparing the installation directory”. 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
Mount the CD with a command like the following:
% mount -o ro -v ’cdrfs’ /dev/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.)
Maintaining consistent ownership and privileges for all files and directories is important. 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. The command in this example 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 df (“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 returned by this command 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.
Running the sybinstall utility
Change directory to the installation directory:
% cd $SYBASE
Start the install utility, sybinstall:
% /cdrom/sybinstall
Follow the instructions at “Installing Sybase IQ ETL Server” or “Installing Sybase IQ Server”