IBM Integration Bus, Version 10.0.0.9 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS


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 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------------------>

>--Integration_Bus_installation_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.

Integration_Bus_installation_directory
(Required) The full path to your IBM® Integration Bus 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® or Informix® database.

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 DD
Informix with DataServer CLI Driver INF
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
DataDirect Connect for ODBC (as of IBM Integration Bus Version 10.0) DD
Informix with DataServer CLI Driver INF

Links created in /var/mqm/exits64

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.

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)
  • iib_install_dir/server/sample/xatm/db2swit
Oracle
  • iib_install_dir/server/ODBC/drivers/lib/libUKicu95.x
  • iib_install_dir/server/ODBC/drivers/lib/libUKssl95.x
  • iib_install_dir/server/ODBC/drivers/lib/UKora95.so
  • iib_install_dir/server/ODBC/drivers/lib/UKoradtc95.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
  • iib_install_dir/server/ODBC/drivers/lib/libUKicu95.x
  • iib_install_dir/server/ODBC/drivers/lib/libUKssl95.x
  • iib_install_dir/server/ODBC/drivers/lib/UKase95.so
  • iib_install_dir/server/ODBC/drivers/lib/UKasedtc95.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/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

bn58000_.htm | Last updated 2017-07-17 12:46:45