Location Connection for Db2 for i - DSS 6 | Data Source Solutions Documentation

Documentation: Location Connection for Db2 for i - DSS 6 | Data Source Solutions Documentation

Location Connection for Db2 for i

This section describes the connection details required for creating Db2 for i location in Data Source Solutions DSS. 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 DSS to the database in Db2 for i.	Database_User
PASSWORD	Password for the USER.	Database_Password
Use SSL `Since v6.1.5/9`	Enable/disable (one way) SSL. If enabled, DSS 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 DSS to the database in Db2 for i.	ODBC_Driver

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 DSS to the database in Db2 for i.

ODBC_Driver