Installing Sybase IQ Extended Enterprise Edition

If you do not require ETL capability, skip to “Installing Sybase IQ Server”.

Installing Sybase IQ ETL Server

1. Run sybinstall as described in “Running the sybinstall utility”.

2. Type the number 1 on the Welcome screen and press Return.

   A message similar to the following displays:

   Sybase IQ ETL Server 4.21 Build 22871
   

3. The procedure displays a list of countries or regions. Type the number that appears beside your country or region. The license agreement displays in your language.

4. Press the spacebar or 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, type “N” and press Return, which exits the installation procedure.

5. After a message about verifying the archive integrity displays, you can specify the installation directory.

   The procedure displays the default directory, for example:

   Installation directory [/disk1/SYBASE/SybaseIQETLServer]
   

   You must have write permission in the installation directory. Accept the default or type the target directory you prefer and press Return. Sybase recommends that installation paths contain only alphanumeric characters.

6. Type “Y” to create the directory if it does not exist or to overwrite an existing target directory. Type “N” to exit the installation.

7. If you typed “Y”, the procedure begins and lists the amount of space required. For example:

   Space needed for installation: 188430 KB
   

8. The procedure automatically configures the package and displays messages that end with the following:

   Installation complete
   

   To reconfigure the package later, you can run the script $SYBASE/SybaseIQETLServer/configure.sh.

9. Press Return to return to the main menu.

   To begin using Sybase IQ ETL, see ETL User’s Guide for Sybase IQ (DC00608-01-0421-01). This document is available online and on the Getting Started Sybase IQ 12.7 Extended Enterprise Edition CD.

10. Enter “Q” to quit the install or “2” to install Sybase IQ Server. See the next procedure to install Sybase IQ Server.

Installing Sybase IQ Server

1. Run sybinstall as described in “Running the sybinstall utility”.

   You can optionally use parameters on the sybinstall command line to simplify Sybase IQ Server installation. See “Bypassing sybinstall menus”.

2. On the Welcome screen:

   • If installing Sybase IQ Enterprise Edition, press Return to continue.

   • If installing Sybase IQ Extended Enterprise Edition, enter “2” and press Return, then press Return again at the second Welcome screen.

3. If you have previously installed Sybase IQ, 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 IQ servers running in $SYBASE directory have been shut down before continuing. Do you want to continue <Y/N>?
   

4. If any of the listed servers are running in the $SYBASE directory, enter “N” to 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.”

5. 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
   

6. 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.

7. The script next lists the amount of space available in your $SYBASE directory and the amount of space required to install Sybase IQ and all of its associated products.

8. To accept the default, enter “S.”

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

9. 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.

10. 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.

11. After selecting products, enter “S” to start the installation.

12. 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, then a password. If you do not wish to change the default login or password, type “N.”

13. The procedure begins copying files. As the procedure installs each product selected, it displays a list of the files installed. This may take a few minutes. When finished, the following message displays:

    Product install completed.
    

    Press <Return> to continue:
    

    Press Return.

14. After installing the required components, the install procedure prompts for optional components and keys.

    Enter Component :
    

    If you have no optional components, press Return and type “N” when prompted to enter another component.

    To install optional components, type the component (for example, LOB for Large Object or ENC for Column Encryption). The procedure then prompts for the key.

    Enter Key :
    

    Now type the installation key exactly as it appears on your installation key document. Entering the key returns the message <Component> enabled!.

    When the installation completes, a message lists environment setup files created.

15. If installing Sybase IQ Extended Enterprise Edition, press Return to return to the main menu. Type “Q” to exit the installation program.

Completing the installation

1. Print and read the appropriate Readme file.

   For Sybase IQ ETL, the Readme file displays when you install IQ ETL Development. (See “Installing Sybase IQ ETL Development”.)

   For Sybase IQ Server, see $ASDIR/readme.txt.

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

   % umount /cdrom
   

3. Remove the CD from the drive.

4. 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 multiplexes with Sybase Central.

5. Set the environment variables as described in “Setting environment variables”

6. Log out.

Setting environment variables

These procedures set the ASDIR environment variable used to start and test Sybase IQ. To test Sybase IQ, see “Running Sybase IQ Server”.

Bypassing sybinstall menus

1. Choose one or more of the parameters in Table 2-1.

   Table 2-1: Optional sybinstall parameters for Sybase IQ Server installation

   Parameter	Function
   -add_agent	Install standalone IQ Agent. Use only on systems where IQ is already installed. Do not combine with any other parameters.
   -add_license	Install options ordered and licensed separately.
   -autoinstall	Install all defaults.
   -dst <source|CD-directory>	Install in specified directory
   -help	Display all parameters and usage.
   -I_accept_sybase_license	Bypass license agreement prompt.
   -info|version	Display information about this product.
   -products	Specify product(s) to install. Products not listed are ignored. If a parameter is omitted, all products are installed or selected by user menu selection. Products are: IQ — Sybase IQ OC — Open Client SC — Sybase Central JC5 — jConnect 5.5 JC6 — jConnect 6.0 JRE — Java Runtime Environment
   -src <source|CD-directory>	Specify directory from which to install.
   -unlock	Avoid problems when files to be updated are held in memory. Installs files in a shadow directory, links to the correct location, then removes shadow directory.
   -y	Assume “yes” to all questions, warnings, and errors.

2. Specify the parameters on the command line.

   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 updates Sybase Central and Sybase IQ:

   % /cdrom/sybinstall -autoinstall -update -products "IQ SC" -y
   

   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.

---

Copyright © 2007. Sybase Inc. All rights reserved.

View this document as PDF