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.
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/APVER
OVRSYSDATE/OSVER
ESEND/ESVER
SEQUEL/SQVER
SEQUELWI/SWVER
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 |
Any sample library included with some of the BI products can be excluded.
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.
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.
QIBM\UserData\OpNavPlugin\ASC.ABSTRACT
. \sequel
, \esend
, \helpsystems
and \rio
.QIBM\UserData\OpNavPlugin\ASC.ESEND
.\sequel
, \esend
, \helpsystems
and \rio
./SEQUEL/swi
- path for image and icon files used in the standard Web pages created by SWI.
Still have questions? We can help. Submit a case to Technical Support.