Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
24.2.2 Updating ODBC settings The next step is to modify the settings for the Open Database Connectivity (ODBC) driver. Before you make any modifications, you must first make a backup copy of the .odbc.ini file. For DB2, be sure to verify the ODBC settings. The new product contains new versions of the ODBC drivers for Oracle and Sybase. The full path of the new WebSphere Message Broker V6.0 odbc.ini sample is broker_install_directory/6.0/merant/odbc.ini. Check the differences between the current .odbc.ini file and Message Broker V6.0 sample. Using an editor such as vi, edit the .odbc.ini file and make the required changes by entering the following command: vi /var/mqsi/odbc/.odbc.ini Example 24-7 shows the relevant part of the .odbc.ini file. Example 24-7 Sample of the .odbc.ini [BKA1DB] Driver=/db2data/db2inst1/sqllib/lib/libdb2.a Description=Migration DB Database=BKA1DB