Discovering ODBC data sources on Linux operating systems

To discover ODBC data sources on a Linux® operating system, you must create an ODBC wrapper with the name ODBC.

About this task

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.

What to do next

After you create this ODBC wrapper, the ODBC data sources will be displayed in the Undefined Remote Servers folder.

Feedback