Db2 for z/OS Requirementslink
This section describes the requirements, access privileges, and other features of Fivetran HVR when using 'Db2 for z/OS' for replication.
For information about compatibility and supported versions of Db2 for z/OS with HVR platforms, see Supported Platforms.
For the Capabilities supported by HVR on Db2 for z/OS, see Capabilities for Db2 for z/OS.
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 z/OS, see the Character Encodings page.
Introductionlink
To capture from Db2 for z/OS, HVR 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 HVR will access Db2 on z/OS machine. Additionally, the HVR 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.
HVR requires 'Db2 Connect' for connecting to Db2 for z/OS.
Prerequisites for Fivetran HVR Machinelink
HVR 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 HVR 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 nodename
- 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 password
or
db2cli validate -dsn dsnname -connect -user username -passwd password
- When using Db2 client or Db2 server or Db2 Connect
db2 connect to databasename user userid