Db2 for Linux, Unix and Windows Requirements

This section describes the requirements, access privileges, and other features of Fivetran HVR when using Db2 for Linux, Unix and Windows (LUW) for replication.

Supported Platforms

Learn about the Db2 for LUW versions compatible with HVR on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).

Supported Capabilities

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

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 LUW data types and their mapping, see Data Type Mapping for Db2 for LUW.
Understand the character encodings HVR supports for Db2 for LUW on the Supported Character Encodings page.

Supported Editions

HVR supports the following editions of Db2 for LUW:

Server Edition
Advanced Enterprise Server Edition
Express-C Edition

For information about compatibility and supported versions of Db2 for LUW with HVR platforms, see Supported Platforms.

Prerequisites

HVR requires Db2 client to be installed on the machine from which HVR connects to Db2. The Db2 client should have an instance to store the data required for the remote connection.

The Db2 client must be installed on a machine with the same "endianness" as the machine running the Db2 server. For instance, AIX and Solaris SPARC are big-endian operating systems, while Linux and Windows are little-endian. Therefore, if the Db2 server is running on AIX, the Db2 client should be installed on either AIX or Solaris SPARC.

To set up the Db2 client, use the following commands to catalog the TCP/IP node and the remote database:

db2 CATALOG TCPIP NODE nodename REMOTE remotehost SERVER portnumber

db2 CATALOG DATABASE databasename AT NODE nodename

To test the connection with Db2 server, use the following command:
```
db2 CONNECT TO databasename USER username
```