WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

mqsimanagexalinks command - Linux and UNIX systems

Set up links for a supported database on Linux and UNIX systems for XA coordination under the control of WebSphere® MQ.

Before you start:

Before running this command, read the information in: XA coordination on a system with multiple WebSphere MQ installations.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-mqsimanagexalinks--create--ODBC_driver_type------------------>

>--broker_installation_directory-------------------------------->

>--+-driver_manager_directory--------+-------------------------><
   '-database_installation_directory-'   

Read syntax diagramSkip visual syntax diagram
>>-mqsimanagexalinks--remove--ODBC_driver_type-----------------><

Read syntax diagramSkip visual syntax diagram
>>-mqsimanagexalinks--list-------------------------------------><

Parameters

create
(Required) Specify that the required links are created.
remove
(Required) Specify that the defined links are removed.
ODBC_driver_type
(Required) The ODBC driver type. See the list command for the list of ODBC drivers that are supported.

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.

broker_installation_directory
(Required) The full path to your broker installation.

This parameter is required only if you specify create.

database_installation_directory
(Optional). The full path to your database installation.

This parameter is required only if you specify create, and only for a DB2® database.

driver_manager_directory
(Optional). The full path to your driver manager installation.

This parameter is required only if you specify create, and only for an Oracle or Sybase database. It must be set to the location of the installation directory for your driver manager. For example, the installation location of WebSphere Message Broker ODBC Database Extender.

list
(Required) Display the list of supported ODBC driver versions. Use the output to check what values you can specify for ODBC_driver_type.

For example, the following output is generated on AIX®:

Supported information for the create option.
Supported version of the ODBC drivers Version number for mqsimanagexalinks
DB2 DB2
DataDirect Connect for ODBC V6.0 DD60
DataDirect Connect for ODBC V7.x DD71 (or DD70)
Supported information for the remove option.
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

Links created in /var/mqm/exits

Links are only created in /var/mqm/exits on Linux on x86. The links that are created for each supported database are shown here.

DB2
  • database_install_dir/lib32/libdb2.so
  • database_install_dir/lib32/libdb2.so.1
  • broker_install_dir/sample/xatm/db2swit
Oracle
DataDirect V6.0 Drivers (DD60)
  • broker_install_dir/ODBC/V6.0/lib/libUKicu24.so
  • broker_install_dir/ODBC/V6.0/lib/UKora24.so
  • broker_install_dir/ODBC/V6.0/lib/UKoradtc24.so
  • driver_manager_install_dir/lib/libodbcinst.so
  • driver_manager_install_dir/lib/libodbcinst.so.1
DataDirect V7.x Drivers (DD71)
  • broker_install_dir/ODBC/V7.0/lib/libUKicu26.so
  • broker_install_dir/ODBC/V7.0/lib/UKora26.so
  • broker_install_dir/ODBCV7.0//lib/UKoradtc26.so
  • driver_manager_install_dir/lib/libodbcinst.so
  • driver_manager_install_dir/lib/libodbcinst.so.1
Sybase
DataDirect V6.0 Drivers (DD60)
  • broker_install_dir/ODBC/V6.0/lib/libUKicu24.so
  • broker_install_dir/ODBC/V6.0/lib/UKase24.so
  • broker_install_dir/ODBC/V6.0/lib/UKasedtc24.so
  • driver_manager_install_dir/lib/libodbcinst.so
  • driver_manager_install_dir/lib/libodbcinst.so.1
DataDirect V7.x Drivers (DD71)
  • broker_install_dir/ODBC/V7.0/lib/libUKicu26.so
  • broker_install_dir/ODBC/V7.0/lib/UKase26.so
  • broker_install_dir/ODBC/V7.0/lib/UKasedtc26.so
  • driver_manager_install_dir/lib/libodbcinst.so
  • driver_manager_install_dir/lib/libodbcinst.so.1

Links created in /var/mqm/exits64

Links are created in /var/mqm/exits64 on all Linux and UNIX systems except on Linux on x86. 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.

DB2
  • database_install_dir/lib64/db2o.o (AIX only)
  • database_install_dir/lib64/libdb2o.so (Not on AIX)
  • database_install_dir/lib64/libdb2o.so.1 (Not on AIX)
  • broker_install_dir/sample/xatm/db2swit
Oracle
DataDirect V6.0 Drivers (DD60)
  • broker_install_dir/ODBC/V6.0/lib/libUKicu24.x
  • broker_install_dir/ODBC/V6.0/lib/UKora24.so
  • broker_install_dir/ODBC/V6.0/lib/UKoradtc24.so
  • driver_manager_install_dir/lib/libodbcinst.x
  • driver_manager_install_dir/lib/libodbcinst.so.1 (Linux only)
DataDirect V7.x Drivers (DD71)
  • broker_install_dir/ODBC/V7.0/lib/libUKicu26.x
  • broker_install_dir/ODBC/V7.0/lib/UKora26.so
  • broker_install_dir/ODBC/V7.0/lib/UKoradtc26.so
  • driver_manager_install_dir/lib/libodbcinst.x
  • driver_manager_install_dir/lib/libodbcinst.so.1 (Linux only)
Where .x is the library extension on your platform: .a on AIX or .so on all other platforms.
Sybase
DataDirect V6.0 Drivers (DD60)
  • broker_install_dir/ODBC/V6.0/lib/libUKicu24.x
  • broker_install_dir/ODBC/V6.0/lib/UKase24.so
  • broker_install_dir/ODBC/V6.0/lib/UKasedtc24.so
  • driver_manager_install_dir/lib/libodbcinst.x
  • driver_manager_install_dir/lib/libodbcinst.so.1 (Linux only)
DataDirect V7.x Drivers (DD71)
  • broker_install_dir/ODBC/V7.0/lib/libUKicu26.x
  • broker_install_dir/ODBC/V7.0/lib/UKase26.so
  • broker_install_dir/ODBC/V7.0/lib/UKasedtc26.so
  • driver_manager_install_dir/lib/libodbcinst.x
  • driver_manager_install_dir/lib/libodbcinst.so.1 (Linux only)
Where .x is the library extension on your platform: .a on AIX or .so on all other platforms.

Authorization

The user ID with which you run this command must be root.

Examples

To create the links that are required for DB2:

mqsimanagexalinks create DB2 /opt/IBM/mqsi/8.0.0.2/opt/IBM/db2/V9.7

To create the links that are required for Oracle and Sybase databases (using the DataDirect V6.0 drivers):

mqsimanagexalinks create DD60 /opt/IBM/mqsi/8.0.0.2
To create the links that are required for Oracle and Sybase databases (using the DataDirect V7.1 drivers):
mqsimanagexalinks create DD71 /opt/IBM/mqsi/8.0.0.2 /opt/ibm/IE02/2.0.1

To remove the links that are required for Oracle and Sybase databases (these databases previously used the DataDirect V5.3 drivers):

mqsimanagexalinks remove DD53

To list the supported database drivers:

mqsimanagexalinks list
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:48:23


Reference topicReference topic | Version 8.0.0.7 | bn58000_