Location Connection for Db2 for i
This section describes the connection details required for creating Db2 for i location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating Db2 for i location, see Db2 for i 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 |
|---|---|---|
| SYSTEM | Hostname or IP-address of the Db2 for i system. Example: 192.168.1.135 | Database_Host |
| NAMED DATABASE | Named database in Db2 for i. It could be on another (independent) auxiliary storage pool (IASP). The user profile's default setting will be used when no value is specified. Specifying *SYSBAS will connect a user to the SYSBAS database. | Database_Name |
| USER | Username for connecting HVR to the database in Db2 for i. | Database_User |
| PASSWORD | Password for the USER. | Database_Password |
Use SSLSince v6.1.5/9 | Enable/disable (one way) SSL. If enabled, HVR authenticates the Db2 for i connection by validating the SSL certificate shared by the Db2 for i database server. For SSL connection configuration requirements on Linux, see Configuration for SSL connection on Linux. | Db2_Use_SSL |
Advanced Settings
| Field | Description | Equivalent Location Property |
|---|---|---|
| LINUX / UNIX ODBC DRIVER MANAGER LIBRARY PATH | Directory path where the ODBC Driver Manager Library is installed. This field is applicable only for Linux/Unix operating system. For a default installation, the ODBC Driver Manager Library is available at /usr/lib64 and does not need to be specified. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/lib. | ODBC_DM_Lib_Path |
| LINUX / UNIX ODBCSYSINI | Directory path where the odbc.ini and odbcinst.ini files are located. This field is applicable only for Linux/Unix operating system. For a default installation, these files are available at /etc directory and do not need to be specified using this field. However, when UnixODBC is installed in for example /opt/unixodbc the value for this field would be /opt/unixodbc/etc. The odbcinst.ini file should contain information about the IBM i Access Client Solutions ODBC Driver under the heading [IBM i Access ODBC Driver 64-bit]. | ODBC_Sysini |
| ODBC DRIVER | Name of the user defined (installed) ODBC driver used for connecting HVR to the database in Db2 for i. | ODBC_Driver |