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:
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.
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.
ODBCINI=/var/mqsi/.odbc.ini ODBCINI64=/var/mqsi/odbc64.ini
ODBCINI=/var/mqsi/odbc64.ini ODBCINI32=/var/mqsi/.odbc.ini
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.