Location Connection for Db2 for z/OS

This section describes the connection details required for creating Db2 for z/OS location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Db2 for z/OS location, see Db2 for z/OS Requirements.

If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.

Field	Description	Equivalent Location Property
INSTHOME	When using "Db2 client or Db2 server or Db2 Connect" the directory path of the Db2 installation on HVR machine must be specified. When using "IBM Data Server Driver for ODBC and CLI" the directory path of the IBM Data Server Driver for ODBC and CLI installation on HVR machine (e.g. /distr/db2/driver/odbc_cli/clidriver) must be specified. Example: /db2/11.1	Db2_INSTHOME
DB2INSTANCE	When using "Db2 client or Db2 server or Db2 Connect", the name of the Db2 instance must be specified. When using "IBM Data Server Driver for ODBC and CLI" this field must be left blank/empty. Example: mydb2inst	Db2_DB2INSTANCE
DATABASE	Name of the database. The following formats are supported for this field: alias for the database in Db2 for z/OS database:server:port database is the name of the database in Db2 for z/OS server can either be a hostname or an IP-address of the database server port is the TCP/IP port used for connecting to the database server	Database_Name
USER	Username for connecting HVR to the Db2 z/OS database. Example: hvruser	Database_User
PASSWORD	The password of the USER.	Database_Password