To discover ODBC data sources on a Linux® operating system, you must create
an ODBC wrapper with the name ODBC.
On a Linux operating system, the undefined remote servers
for ODBC data sources do not appear until you create an ODBC wrapper with
the name ODBC. You must create this wrapper from outside of the workbench,
for example, from the DB2® Universal Database™ Control Center
or from a command line. You must name the wrapper ODBC so that the data sources
are properly discovered.
The wrapper on a Linux operating system is defined with
a MODULE wrapper option, as in the following example:
CREATE WRAPPER odbc LIBRARY 'libdb2rcodbc.so' OPTIONS (MODULE '/usr/lib/odbc.so')
where
MODULE '/usr/lib/odbc.so' is the full path to the
library that contains the ODBC Driver Manager.
After you create this ODBC wrapper, the ODBC data sources will be
displayed in the Undefined Remote Servers folder.