Db2 for Linux, Unix and Windows Requirementslink
Updated October 31, 2023
This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using Db2 for Linux, Unix and Windows (LUW) for replication.
For information about compatibility and supported versions of Db2 for LUW with Local Data Processing platforms, see Supported Platforms.
For the Capabilities supported by Local Data Processing 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 Local Data Processing on Db2 for LUW, see the Character Encodings page.
Supported Editionslink
Local Data Processing 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 Local Data Processing platforms, see Supported Platforms.
Prerequisiteslink
Local Data Processing requires Db2 client to be installed on the machine from which Local Data Processing 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 on which the Db2 server is running. AIX and Solaris SPARC are big endian operating systems. Linux and Windows are little endian operating systems. So, for example, if the Db2 server is running on AIX, then Db2 client should be installed either on 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 nodename server portnumber
db2 catalog database databasename at node nodename
content_copyTo test the connection with Db2 server, use the following command:
db2 connect to databasename user username
content_copyFor more information about configuring Db2 client, refer to IBM Knowledge Center.