Set up links for a supported database on Linux and UNIX systems for XA coordination under the control of WebSphere® MQ.
Before running this command, read the information in: XA coordination on a system with multiple WebSphere MQ installations.
>>-mqsimanagexalinks--create--ODBC_driver_type------------------> >--Integration_Bus_installation_directory-----------------------> >--+---------------------------------+------------------------->< '-database_installation_directory-'
>>-mqsimanagexalinks--remove--ODBC_driver_type-----------------><
>>-mqsimanagexalinks--list-------------------------------------><
This parameter is required if you specify create, and is optional if you specify remove. If you specify remove and omit this parameter, all links are removed.
This parameter is required only if you specify create.
This parameter is required only if you specify create, and only for a DB2® or Informix® database.
For example, the following output is generated on AIX®:
Supported version of the ODBC drivers | Version number for mqsimanagexalinks |
---|---|
DB2 | DB2 |
DataDirect Connect for ODBC | DD |
Informix with DataServer CLI Driver | INF |
Supported version of the ODBC drivers | Version number for mqsimanagexalinks |
---|---|
DB2 | DB2 |
DataDirect Connect for ODBC V5.2 | DD52 |
DataDirect Connect for ODBC V5.3 | DD53 |
DataDirect Connect for ODBC V6.0 | DD60 |
DataDirect Connect for ODBC V7.0 | DD70 |
DataDirect Connect for ODBC V7.1 | DD71 |
DataDirect Connect for ODBC (as of IBM Integration Bus Version 10.0) | DD |
Informix with DataServer CLI Driver | INF |
Links are created in /var/mqm/exits64 on all Linux and UNIX systems. The links that are created are shown later in this section for each supported database. Not all links are created on all platforms; the links that are created are determined by the database support on each platform. In the links that are shown, x represents the relevant library extension on your platform.
The user ID with which you run this command must be root.
To create the links that are required for DB2:
mqsimanagexalinks create DB2 /opt/IBM/mqsi/10.0.0.2 /opt/IBM/db2/V10.1
To create the links that are required for Oracle and Sybase databases:
mqsimanagexalinks create DD /opt/IBM/mqsi/10.0.0.2
To remove the links that are required for Oracle and Sybase databases (these databases previously used the DataDirect V7.0 drivers):
mqsimanagexalinks remove DD70
To list the supported database drivers:
mqsimanagexalinks list