MySQL ODBC

Application

DB2 ODBC

Application

Conversion

Application

ODBC Driver Manager

.odbc.ini

odbcinst.ini

.odbc.ini 

odbcinst.ini

db2 cli.ini

ODBC Driver Setup 

Conversion

MyODBC 

DB2 ODBC Driver

MySQL Server

Database

DB2 Server

Conversion

Figure 7 6   ODBC application conversion from MyODBC to DB2 ODBC Driver

Typically, the MyODBC connector has five components:

Application 

As both MyODBC and DB2 CLI are based on ODBC specification, 

applications do not require many changes. Though you have to perform some 

tasks such as:

  Changing SQL queries

  Changes in transaction management

  Proprietary methods changes, deviation from ODBC or additional 

methods.

ODBC Driver Manager

DB2 CLI/ODBC Driver does not come with ODBC Driver Manager. When 

using an ODBC application you must ensure that an ODBC Driver Manager is 

installed and users who will use ODBC have access to it. 

ODBC.ini

The ODBC Driver Manager uses two initialization files:

212 

MySQL to DB2 UDB Conversion Guide