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.

Product

If  version  is less  than:

Exclude Data  Area Object:

If version  is greater  than:

Exclude  User  Space  Object:

Anydate

1.6.306

ASC#OS

1.7.171

ANY815US

Abstract

10.7.235

ASC#AP

10.7.235

ABS815US

Esend

3.7.233

ASC#ES

3.7.233

ESN815US

Sequel

8.7.235

ASC#SQ

8.7.235

SQL815US

Sequel Web Interface

4.7.121

ASC#SW

4.7.121

SWI815US

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.

CPIALL CPI432B CPI432A CPI432C
CPI432E CPI432F CPI432L CPI4321
CPI4322 CPI4323 CPI4324 CPI4325
CPI4326 CPI4327 CPI4328 CPI4329
QRYSUM
(PF and all LF’s)
QRYTOTAL    

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.

 

 

 

 

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: July 12, 2019