WebSphere Message Brokers
File: ah23960_
Writer: Kate Hostler

Task topic

This build: July 31, 2007 21:30:42

Updating your ODBC definitions when migrating

As part of migrating a broker, you must create ODBC definitions for broker and userdatabases, with database drivers that are appropriate for the new product version.

You must complete this update before you run the mqsimigratecomponents command. Follow the instructions provided for your operating system:

Windows®

ODBC definitions are stored by the operating system in a single repository of ODBC data source names. Change Oracle and Sybase data source definitions according to the instructions in Changing the ODBC connection and XA resource manager definitions for a migrated broker.

You do not need to change DB2®, Informix, and SQL Server data source definitions.

Linux® and UNIX

ODBC definitions are stored in a text file. For previous versions of the product, the file .odbc.ini was located in /var/mqsi/odbc/. When working with Version 6.1, create a new text file under this directory, but do not replace the existing file. When you use a different file, you do not affect existing brokers. Set the environment variable ODBCINI to point to the new file; perform this step as part of the setup for a Version 6.1 command environment.

In your new Version 6.1 ODBC configuration file, ensure that you list all of the data sources that will be used by brokers that you want to migrate. For information on how to create a new ODBC configuration file, see Connecting to a database from Linux and UNIX systems.

Start of changeSample ODBC files are provided; .odbc.ini is supplied for 32-bit connections and odbc64.ini is supplied for 64-bit connections. However, the default environment variables have changed. The following values are set in mqsiprofile for Version 5.0 and Version 6.0:End of change

Start of change
ODBCINI=/var/mqsi/.odbc.ini
ODBCINI64=/var/mqsi/odbc64.ini
End of change

Start of changeThe following values are set in mqsiprofile for Version 6.1:End of change

Start of change
ODBCINI=/var/mqsi/odbc64.ini
ODBCINI32=/var/mqsi/.odbc.ini
End of change

Start of changeUpdate the values in mqsiprofile for Version 6.1 if you want to retain the existing values.End of change

If you are using XA to enable coordinated transactions, you must also update your qm.ini file for WebSphere® MQ, as described in Changing the ODBC connection and XA resource manager definitions for a migrated broker.

If you revert to a previous version of WebSphere Message Broker, you must reverse the changes that you make to the ODBC definitions. Update the odbc.ini after you have run the mqsimigratecomponents command, but before you restart the broker. If you are reverting to Version 5.0, follow the instructions in Restoring components and resources to Version 5.0. If you are reverting to Version 6.0, follow the instructions in Restoring components and resources to Version 6.0.

Related tasks
Enabling connections to the databases
Connecting to a database from Linux and UNIX systems
Connecting to a database from Linux and UNIX systems: 32-bit considerations
Changing the ODBC connection and XA resource manager definitions for a migrated broker
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:30:42

ah23960_ This topic's URL is: