Db2 for z/OS Requirementslink
Updated October 31, 2023
This section describes the requirements, access privileges, and other features of Fivetran Local Data Processing when using 'Db2 for z/OS' for replication.
For information about compatibility and supported versions of Db2 for z/OS with Local Data Processing platforms, see Supported Platforms.
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 z/OS, see the Character Encodings page.
To capture from Db2 for z/OS, Local Data Processing needs to be installed on a separate machine(either 64-bit Linux on Intel or 64-bit Windows on Intel or 64-bit AIX on PowerPC) from which Local Data Processing will access Db2 on z/OS machine. Additionally, the Local Data Processing stored procedures need to be installed on Db2 for z/OS machine for accessing Db2 log files. For steps to install the stored procedures on Db2 for z/OS machine, see section Installing Capture Stored Procedures.
Local Data Processing requires 'Db2 Connect' for connecting to Db2 for z/OS.
Prerequisites for Fivetran Local Data Processing Machinelink
Local Data Processing requires the IBM Data Server Driver for ODBC and CLI or Db2 client or Db2 server or Db2 Connect to be installed on the machine from which Local Data Processing connects to Db2 on z/OS. The Db2 client should have an instance to store the data required for the remote connection.
To install the IBM Data Server Driver for ODBC and CLI, refer to the IBM documentation.
To set up the Db2 client or Db2 server or Db2 Connect, use the following commands to catalog the TCP/IP node and the remote database:
db2 catalog tcpip node nodename remote hostname server portnumber db2 catalog database databasename at node nodenamecontent_copy
- nodename is the local nickname for the remote machine that contains the database you want to catalog.
- hostname is the name of the host/node where the target database resides.
- databasename is the name of the database you want to catalog.
For more information about configuring Db2 client or Db2 server or Db2 Connect, refer to IBM documentation.
Verifying Connection to the Db2 Serverlink
To test the connection to the Db2 server on the z/OS machine, use the following command:
When using IBM Data Server Driver for ODBC and CLI
db2cli validate -database databasename:servername:portnumber -connect -user username -passwd passwordcontent_copy
db2cli validate -dsn dsnname -connect -user username -passwd passwordcontent_copy
- When using Db2 client or Db2 server or Db2 Connect
db2 connect to databasename user useridcontent_copy