Replicating Business Intelligence Products in a High Availability Environment

This document addresses considerations when configuring replication of a BI product library (Abstract, Anydate, Esend, Sequel, Sequel Web Interface) using a high availability solution.

The sections below list mandatory and optional items to exclude. All other objects in the BI product libraries and IFS folders should be INCLUDED in your replication configuration.

Mandatory Items to Exclude

Based on product version, the data area (DTAARA), or user space (USRSPC) objects listed below should not be replicated. Overwriting these items will affect the proper operation of the product.

Issue the following commands to check your current installed version.

Abstract:

ABSTRACT/APVER

Anydate:

OVRSYSDATE/OSVER

Esend:

ESEND/ESVER

Sequel:

SEQUEL/SQVER

Sequel Web Interface:

SEQUELWI/SWVER

Sequel Auditing Files to Exclude

If you are using the SEQUEL Auditing feature, the list of files below must be excluded from replication in your high availability solution. All of these files are in the SEQUEL library.

Optional Items to Exclude

Any sample library included with some of the BI products can be excluded.

• SEQUELEX
• APLSAMPLE
• ASCSUPPORT

No other objects in any of the Business Intelligence product libraries are affected by the mirroring/replication process.

Note: Any user library that contains Sequel view, report, and table objects should be replicated. These items are created as user space (USRSPC) objects.

IFS Items to Include

SEQUEL, ABSTRACT, ESEND and SEQUEL Web Interface (SWI) install System i Plugin components and various files in several folders on the IFS. These items should be INCLUDED in your replication configuration.

For Abstract:

• Operations Navigator Abstract plug-in: QIBM\UserData\OpNavPlugin\ASC.ABSTRACT.
• All files installed in the folders: \sequel, \esend, \helpsystems and \rio.

For Sequel, Esend, and SWI:

• Operations Navigator Esend plug-in: QIBM\UserData\OpNavPlugin\ASC.ESEND.
• All files installed in the folders: \sequel, \esend, \helpsystems and \rio.
• Any IFS directories in the - /SEQUEL/swi - path for image and icon files used in the standard Web pages created by SWI.
• Any product to be replicated should be installed on the target system prior to the replication process.