Updating your ODBC definitions when migrating

As part of migrating a broker, you create ODBC definitions for broker databases that specify appropriate database drivers for the new product version.

Complete this update before you run the mqsimigratecomponents command.

Follow the instructions provided for your operating system:

Windows® systems

The operating system stores ODBC definitions in a single repository of ODBC data source names. Change Oracle and Sybase data source definitions according to the instructions in Changing the 32-bit ODBC connection and XA resource manager definitions for a broker migrated from Version 2.1 or Version 5.0 to Version 6.0

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

Linux® and UNIX® systems

ODBC definitions are stored in a text file. For previous versions of the product, the file .odbc.ini is located in /var/mqsi/odbc/. When working with Version 6.0, create a new text file in this directory, but do not replace the existing file to avoid affecting 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.0 command environment.

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

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 32-bit ODBC connection and XA resource manager definitions for a broker migrated from Version 2.1 or Version 5.0 to Version 6.0

If you revert to a previous version of WebSphere Event 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.

Related tasks
Enabling ODBC connections to the databases
Connecting to a database from Linux and UNIX systems
Connecting to a database from Linux and UNIX systems: 64-bit considerations
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009. All Rights Reserved.
Last updated : 2009-01-07 15:40:37

ah23960_