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.
Item | Requirement |
---|---|
Operating system | For a Windows environment, either:
For a UNIX environment, either:
|
Database | One of the following versions of Oracle server and client:
One of the following versions of Db2 LUW server and client, running on IBM AIX or Oracle Solaris:
|
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:
- Uninstall (remove) the previous version (see Uninstalling-High-speed-Apply-Engine)
Drop the existing restart table (see Dropping-an-existing-restart-table)
High-speed Apply Engine does not migrate restart tables from previous versions and does not drop existing restart tables.
- 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.
- If you have a previous version of High-speed Apply Engine installed on your system, complete the following procedures before installing the current version:
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 |
|
/High-speed Apply/examples/db2udb (For Db2 LUW targets) |
|
/High-speed Apply/examples/oracle (For Oracle targets) |
To start the installation wizard
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.
- Click Next.The installation wizard displays the License Agreement.
- 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.
- 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.
- Click Install.
- 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.
Continue with the steps in the following procedure.
To create a restart table (Setup Product)
Use this procedure to create the default restart table during the installation process.
- On the Select Options dialog box, select Setup Product, and click Next.
- In the Database Type selection window, select DB2 or Oracle as the database type, and then click Next.
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
The installation wizard creates the restart table, and displays the Setup Output window.
Examine the messages to verify that the restart table was created successfully, and then click Next.
The installation wizard displays the ReadMe File Selection dialog box.
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.
- Click Done to close the installation wizard.
Related topics