Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see High-speed Apply Engine 13.1.

Installing High-speed Apply Engine on UNIX or Windows


This section describes the requirements and procedures for installing the High-speed Apply Engine product on a UNIX or a Microsoft Windows system. This information applies to IBM Db2 LUW and Oracle targets.

Overview and prerequisites

To install and run High-speed Apply Engine, your software environment must meet the requirements shown in the following table.

Important

For the most recent information about installing High-speed Apply Engine, see the Installation System documentation and the readme file (on the software CD, in the root directory). The Installation System documentationand readme contain the most current updates to the installation information.


Item

Requirement

Operating system

For a Windows environment, either:

  • Windows 2007
  • Windows 2008

For a UNIX environment, either:

  • IBM AIX, Version 6.1 and 7.1
  • Oracle Solaris, version 10 or later

Database

One of the following versions of Oracle server and client:

  • 11.1
  • 11.2

One of the following versions of Db2 LUW server and client, running on IBM AIX or Oracle Solaris:

  • 9.7
  • 9.8
  • 10

Storage

100 MB of available storage for each installed copy of High-speed Apply Engine

Installation considerations

When you install the High-speed Apply Engine on a UNIX or Microsoft Windows system, consider the following constraints and recommendations:

  • On Windows you must have, and be logged in with, Administrator privileges. On UNIX you must have permission to update the /etc and /opt directories.
  • To run the Windows installer, you must have Oracle Java version 5 or later installed.
  • High-speed Apply Engine must be installed on the same server or client system as the target database server or client.
  • The target database must have enough threads available to process the apply request. Ensure that at least two threads are available, or one thread more than the maximum number of agents for the request.
  • The restart table must reside in the same database as the target tables.
  • The user ID that submits the apply request must have the appropriate authorizations to run the request. For more information, see Controlling access.
  • Before you begin the High-speed Apply Engine installation, we recommend the following actions:
    • If you have a previous version of High-speed Apply Engine installed on your system, complete the following procedures before installing the current version:
    • Review the High-speed Apply Engine readme file, which contains the most recent changes and additions to the documentation, including installation procedures. The file is located on the CD with the software, in the root directory. The file name begins with readme and is available in ASCII text and HTML format. 

Controlling access

To run the High-speed Apply Engine, you must have a valid Db2 LUW or Oracle user ID and a password with the following privileges:

  • Appropriate table privileges (INSERT, UPDATE, and DELETE) on the target tables that are changed by the apply request

    The privileges that High-speed Apply Engine requires depend on the transactions that an apply request performs on the target tables.

  • INSERT, UPDATE, SELECT and DELETE privileges on the restart table that an apply request uses

Using the installation wizard

The following procedures explain how to use the installation wizard to:

  • Install High-speed Apply Engine for the first time
  • Replace an existing version of High-speed Apply Engine
  • Create a default restart table, and bind for Db2 LUW
  • Verify the installation
  • View the readme file
  • View the log

The installation wizard copies the program files to the installation directory that you specify, creates the subdirectories shown in the following table, and registers High-speed Apply Engine and its components by updating the registry on Windows and creating /etc/bmc.profile and updating /etc/profile on UNIX platforms.

Subdirectory

Contents

/InstallationFolder/highspeedapply

Windows program files

/InstallationDirectory/highspeedapply/bin

AIX or Solaris executables and shared libraries

/High-speed Apply/doc

  • readme file (in text and HTML formats)

    This file contains the most recent changes and additions to the documentation, including installation procedures.

  • High-speed Apply Engine documentation

/High-speed Apply/examples/db2udb

(For Db2 LUW targets)

  • Sample configuration files
  • Sample SQL to create restart tables (and bind files for Db2 LUW)

/High-speed Apply/examples/oracle

(For Oracle targets)

To start the installation wizard

  1. Insert the CD in the CD-ROM drive of the computer where you want to install High-speed Apply Engine.The installation wizard begins and displays the Welcome window.

    Important

    If the installation wizard does not begin automatically, complete the appropriate steps:

    • For Windows:
      1. In Windows Explorer, open the Windows directory on the CD.
      2. Double-click setup.cmd (the Windows Command Script).
      3. If prompted, click Run.
    • For UNIX:
      1. Go to one of the appropriate directories.
        1. For Solaris: cdrom/unix/solaris
        2. For AIX: cdrom/unix/aix

    GUID-F3462458-903E-4D51-B301-C19524DBF0A9-low.png

  2. Click Next.The installation wizard displays the License Agreement.
  3. Read the license agreement, click I agree to the terms of the license agreement, and click Next.The installation wizard displays the Directory Selection dialog box.
  4. Accept the displayed directory or click Browse to select a directory, and then click Next.The installation preview window shows the destination directory, the features to be installed, and the size of the files.
  5. Click Install.
  6. In The Update PATH Environment Variable dialog box, select Yes to insert the High-speed Apply Engine directory at the beginning of the system-level PATH environment variable, and then click Next.The installation wizard displays the Select Options dialog box.
  7. Continue with the steps in the following procedure.

    Important

    If you are installing the product on a UNIX server (Solaris or AIX), the Installer will create or update file /etc/bmc.profile and add the environment variable HIGHSPEEDAPPLY_HOME to point to the directory where the product is installed. This environment variable is used by the product's apeenv and the Setup/Verify (SV.sh) scripts found in the examples subdirectories. It will also update the /etc/profile to source bmc.profile. If you choose to set the PATH variables during installation, the PATH and LD_LIBRARY_PATH (LDLIBPATH in AIX) will also be updated and set in bmc.profile. The /etc/bmc.profile is also used by other BMC products that are installed on the server.

To create a restart table (Setup Product)

Use this procedure to create the default restart table during the installation process.

Important

For information about creating the restart table after installation, see Creating-a-default-restart-table-after-installation.

  1. On the Select Options dialog box, select Setup Product, and click Next.
  2. In the Database Type selection window, select DB2 or Oracle as the database type, and then click Next.
  3. Enter information about the specific Db2 LUW database or Oracle instance to which High-speed Apply Engine will apply changes, and then click Next.The user ID and password are not required if:

    • You use Oracle External Credentials (OPS$) in your environment
    • You use Db2 LUW and you are running on the server where the database resides

    Tip

    If necessary, obtain this information from database administration personnel at your site.

    The installation wizard creates the restart table, and displays the Setup Output window.

  4. Examine the messages to verify that the restart table was created successfully, and then click Next.

    Important

    If the restart table was not created successfully, minimize the installation wizard and resolve the error. Ensure that you have the correct privileges and connectivity for the Db2 LUW database or Oracle instance. For more information, see Viewing-logs. If you cannot resolve the error, contact BMC Software Support.

    The installation wizard displays the ReadMe File Selection dialog box.

  5. Select Yes, and then click Next.The installation wizard opens the readme file (with Notepad as the text editor), and displays the Installation Summary window. If you are installing on a UNIX server, the readme file is displayed in the Installer's dialog.

    Tip

    You can go back to previous screens to run the Verify after the Restart table is created and before exiting the Installer (for example, before selecting Next to go to installation summary screen). In addition, on AIX and Solaris, you can run the Setup/Verify step on the command line outside the Installer by going to the desired DBMS subdirectory (db2usdb or oracle) under the examples directory and invoking SV.sh script, as follows:

    Usage: SV.sh SETUP|VERIFY db_instance [user_ID] [user_password]

  6. Click Done to close the installation wizard.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*