Db2 for i Requirementslink
This section describes the requirements, access privileges, and other features of Fivetran HVR when using Db2 for i for replication.
For information about compatibility and supported versions of Db2 for i with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Db2 for i, see Capabilities for Db2 for i.
For information about the supported data types and mapping of data types in source DBMS to the corresponding data types in target DBMS or file format, see Data Type Mapping.
For the character encodings supported by HVR on Db2 for i, see the 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 Connectionlink
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.
Firewalllink
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.