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.
For information about compatibility and supported versions of Db2 for LUW with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Db2 for LUW, see Capabilities for Db2 for Linux, Unix and Windows.
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 LUW, see the 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
For more information about configuring Db2 client, refer to Db2 documentation.