Configuring the Federator to mirror data on a database

Starting from the Dynamic Workload Console V10.2.3, the Federator component is automatically installed with the console to mirror (replicate) the events related to the z/OS current plan on a configured database. The supported databases are those supported by the Dynamic Workload Console, except for Informix.

Before you begin

The mirroring function has the following prerequisites:

HCL Workload Automation for Z v10.2, or later.
If you are using Db2 for z/OS, ensure that you have:
- Installed IBM Db2 for z/OS V13.1.503, or later.
- Installed IBM Db2 Accessories Suite for z/OS for Db2 13 for z/OS V04.02.00, or later.
- Defined a Workload Manager (WLM) policy for the required Db2 for z/OS environment and that a Db2 procedure for the WLM Application environment is up and running.

About this task

Data mirroring enables you to:

Monitor your objects from the Orchestration Monitor page of the Dynamic Workload Console (for details, see Orchestration Monitor overview).
Starting from DWC 10.2.4, you can also run OQL queries (for details, see Using Orchestration Query Language).
Perform actions on the monitored objects through the REST APIs V2, with which you can also run OQL queries. (For details, see Using Orchestration Query Language.)

To configure the Federator, perform the following steps:

According to your operating system, browse to the fed_variables.xml file, which is created at installation time in the following folder:

Windows

<DATA_dir>\usr\servers\dwcServer\configDropins\overrides

UNIX and z/OS

<DATA_dir>/usr/servers/dwcServer/configDropins/overrides
Edit the file by setting the following variables:
federator.secret
The secret key string to register the z/OS engine to the Federator, in the format UTF-8. Ensure that you:
- Use a character set that is compatible with the CODEPAGE parameter specified in the OPCOPTS initialization statement.
- Specify this same value in the SECRET parameter of the MIRROPTS statement.
This variable is case-sensitive. You can specify up to 36 alphanumeric characters. Special characters, except blanks and single quotation marks, are allowed.
mirroring.cleanup.interval
Number of days after which the following records are deleted from the database:
- Records flagged as archived
- Records not updated over that time range which are no longer in the current plan.
The default is 0, meaning that the database stores only the records that are present in the current plan.
uno.federator.engine.jwt.expiration.duration

The interval of time after which the authentication token expires, set in the ISO 8601 format. For example, to specify an interval of 50 days, set P50D. To specify an interval of 45 hours, set PT45H. The default is 30 days.
According to your operating system browse to the jwtsso.xml file, which is created at installation time in the following folder:

Windows

<DWC_home>\usr\servers\dwcServer\configDropins\templates

UNIX and z/OS

<DWC_home>/usr/servers/dwcServer/configDropins/templates

and copy it to the following folder:

Windows

<DATA_dir>\usr\servers\dwcServer\configDropins\templates

UNIX and z/OS

<DATA_dir>/usr/servers/dwcServer/configDropins/templates
Edit the jwtsso.xml file by replacing the following variables:
```
<variable name="dwc.portNumber" value="9443"/>
<variable name="dwc.url" value="<localhost>"/>
keyAlias="<server>"
```
9443

The actual port number used to connect with the Dynamic Workload Console. It must be coincident with the value set for variable name="host.https.port" in the ports_variables.xml file located in the following folder:

Windows

<DATA_dir>\usr\servers\dwcServer\configDropins\overrides

UNIX and z/OS

<DATA_dir>/usr/servers/dwcServer/configDropins/overrides

localhost

The IP address of the z/OS LPAR where the Dynamic Workload Console is installed.

server

The alias specified in your key store. (To retrieve this information, issue the z/OS command keytool -v -list -keystore TWSServerKeyFile.p12.)
If you are upgrading from any version earlier than 10.2.3, browse to the datasource_db_vendor.xml file, which is created at installation time in the following folder:

Windows

<DWC_home>\usr\servers\dwcServer\configDropins\templates\datasources

UNIX and z/OS

<DWC_home>/usr/servers/dwcServer/configDropins/templates/datasources

In the datasource_db_vendor.xml file, locate the section named jndiName="jdbc/feddb" and copy it into the datasource.xml file located in the following path:

Windows

<DATA_dir>\usr\servers\dwcServer\configDropins\overrides

UNIX and z/OS

<DATA_dir>/usr/servers/dwcServer/configDropins/overrides
Stop and restart the Dynamic Workload Console server.