Location Connection for Db2 for LUW

This section describes the connection details required for creating Db2 for Linux, UNIX and Windows (LUW) location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Db2 for LUW location, see Db2 for Linux, UNIX and Windows 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 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/9.7	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: db2instl	Db2_DB2INSTANCE
DATABASE	Name of the Db2 database. The following formats are supported for this field: alias for the database in Db2 for LUW database:server:port database is the name of the database in Db2 for LUW 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 Example: mytestdb	Database_Name
USER	Username for connecting HVR to the Db2 database. Example: hvruser	Database_User
PASSWORD	Password for the USER.	Database_Password