Configuring ODBC on Linux

To configure ODBC, you can use the graphical user interface to run the ODBC configuration utility that is supplied with your Linux distribution, or you can edit the odbc.ini file with the settings described in these steps. (These steps show the ODBC Administrator tool launched from the ODBCConfig graphical interface utility for Linux.)

Download and install the 32-bit or 64-bit iSeries Access ODBC driver on the remote Linux system according to the vendor documentation. The iSeries ODBC driver is supplied as a free component of iSeries Access.
Issue one of the following commands, depending on the driver that you want to use.
32-bit driver:
```
rpm -ivh iSeriesAccess-7.1.0-1.0.i386.rpm
```
64-bit driver:
```
rpm -ivh iSeriesAccess-7.1.0-1.0.x86_64.rpm
```
You can create a user DSN (a connection that is available only to the user that created it) or a system DSN (a connection that is available to all users on the system). To create a user DSN, log on to the system as the user that you will be using for the Replicat process.
Run the ODBC configuration utility.
On the initial page of the ODBC configuration tool, select the User DSN tab to create a user DSN or the System DSN tab to create a system DSN. (These steps create a user DSN; creating a system DSN is similar.)
On the tab you selected, click Add.
Select the appropriate iSeries Access ODBC driver, click OK. If the correct driver is not shown in the Select the DRIVER list, click the Add button and then complete the fields.
Steps to complete the Driver Properties fields when the driver is not found:
- Set Name to the name of the driver.
- Set Driver to the path where the driver is installed.
- Set Setup to the libcwbodbci.so file that is in the driver installation directory.
- Leave the other settings to their defaults.
- Click the check mark above the Name field to save your settings.
In the Name field of the Data Source Properties dialog, supply a one-word name for the data source. In the System field, enter the fully qualified name of the target DB2 for i system, for example: sysname.company.com. Leave the UserID and Password fields blank, to allow Replicat to supply credentials when it connects to the database. Leave the remaining fields set to their defaults, and then click the check mark above the Name field to save your settings.
You are returned to the ODBC Data Source Administrator dialog. Click OK to exit the ODBC configuration utility.
To support GRAPHIC, VARGRAPHIC and DBCLOB types, edit the .odbc.ini file and add the following line.
```
GRAPHIC = 1
```
Note:

If you created a user Data Source Name, this file is located in the home directory of the user that created it. If you created a system DSN, this file is in /etc/odbc.ini or /usr/local/etc/odbc.ini.
From the Oracle GoldenGate directory on the target, run GGSCI and issue the DBLOGIN command to log into the target database.
```
DBLOGIN SOURCEDB database, USERID db_user [, PASSWORD pw [encryption options]]
```
Where:
- SOURCEDB database specifies the new Data Source Name.
- USERID db_user, PASSWORD pw are the Replicat database user profile and password.
- encryption options is optional password encryption.
Note:

Only BLOWFISH encryption is supported for DB2 for i systems.