This document addresses considerations when configuring replication of a Showcase 10 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 greater  than:

Exclude  User  Space  Object:

Esend

3.4.6

ESN815US

Showcase

10.00

SQL815US

Sequel Web Interface

10.19

SWI815US

Issue the following commands to check your current installed version.

Esend:

ESEND/ESVER

Showcase 10:

SCSERVER10/SCVER

Sequel Web Interface:

SEQUELWI/SWVER

Auditing Files to Exclude

If you are using the Auditing feature, the list of files below must be excluded from replication in your high availability solution. All of these files are in the SCSERVER10 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 Showcase 10 can be excluded.

  • SEQUELEX
  • ASCSUPPORT

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

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

IFS Items to Include

Showcase 10, 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 Showcase 10, Esend, and SWI:

  • Operations Navigator Esen plug-in: QIBM\UserData\OpNavPlugin\ASC.ESEND.
  • All files installed in the folders: \sequel, \esend, \helpsystems, \rio,and \skyagent.
  • Any IFS directories in the - /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.

Last Modified On: February 14, 2019