Db2 for i Requirements

This section describes the requirements, access privileges, and other features of Fivetran HVR when using Db2 for i for replication.

Supported Platforms

Learn about the Db2 for i versions compatible with HVR can be found on our Platform Support Matrix page (6.1.0, 6.1.5, and 6.2.0).

Supported Capabilities

Discover what HVR offers for Db2 for i on our Capabilities for Db2 for i page (6.1.0, 6.1.5, and 6.2.0).

Data Management

Learn how HVR maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported Db2 for i data types and their mapping, see Data Type Mapping for Db2 for i.
Understand the character encodings HVR supports for Db2 for i on the Supported Character Encodings page.

Fivetran provides additional solutions for replicating data from Db2 for i. For more information, see section Db2 for i in Databases.

ODBC Connection

HVR is not installed on the Db2 for i system itself but is instead installed on a Linux or Windows machine, from which it uses ODBC to connect to the Db2 for i system. HVR uses ODBC connection to read and write data to Db2 for i location.

The following are required for HVR to establish an ODBC connection to the Db2 for i system:

On Linux:
- IBM i Access Client Solutions ODBC Driver 64-bit
- ODBC driver manager UnixODBC
On Windows:
- IBM i Access Client Solutions ODBC Driver

The IBM i Access Client Solutions ODBC Driver is available for download from IBM ESS Website (requires user authentication). Choose product-number '5770-SS1', and then choose package 'IBM i Access - Client Solutions' for your platform. For information about the supported ODBC driver version, refer to the HVR release notes (hvr.rel) available in the HVR_HOME directory or the download page.

SSL Connection

Since v6.1.5/9

HVR supports SSL connection for Db2 for i on both Linux and Windows.

To enable SSL authentication for a Db2 for i location, select the Use SSL option while creating a location or by editing the existing location's source and target properties (or define the equivalent location property Db2_Use_SSL).

Configuration for Linux

To use SSL with HVR installed on Linux, you need to configure the OpenSSL libraries using one of the following options:

Option 1: Delete the libcrypto.so.x library located in the $HVR_HOME/lib directory and ensure that the appropriate OpenSSL library is installed on the machine.
Option 2: Create a symbolic link from the system trust store:
1. Run the following command to locate your system's trust store:
```
openssl version -d
```
  This command will return a path, typically /usr/lib/ssl or /etc/ssl.
2. Append /certs to the path returned by the previous command to locate your system's certificate store.
3. Create a symbolic link from this directory to /usr/local/ssl/certs by executing the following command:
```
sudo ln -s /usr/lib/ssl/certs /usr/local/ssl/certs
```

For information about the ODBC driver version that supports SSL connection on Linux, refer to the HVR release notes (hvr.rel) available in the HVR_HOME directory or the download page.

Firewall

If a Firewall is configured between the HVR capture machine and the IBM i-series, the following default ports need to be opened in order to be able to connect via ODBC from the capture to the IBM i-series:

PC Function	Service name i-series	Port non-SSL	SSL Port
Server mapper	as-svrmap	449	449
License Management	as-central	8470	9470
RPC/DPC (Remote command)	as-rmtcmd	8475	9475
Sign-On Verification	as-signon	8476	9476
Database Access	as-database	8471	9471

The port numbers mentioned here are the default port numbers. To verify the default port numbers for the services names, use the command wrksrvtble on AS/400 console.