If your message flow interacts with an Oracle database, and you want to coordinate the updates made to the database with other actions within the message flow, configure your broker to manage these updates.
Before you start:
To complete this task, you must have completed the following task:
If you want to use Sybase in coordinated transactions, follow the general instructions in the section called "Sybase configuration" in the WebSphere MQ System Administration book, and use these with the instructions given here. WebSphere Message Broker supports only Sybase Version 12_5.
The following examples show what you must include in the XAResourceManager stanza in the qm.ini file on UNIX systems, and the equivalent Windows information. In each example, uid represents the user login and pwd the user ID's password.
XAResourceManager: Name=SYBASEXA SwitchFile=<Your install directory>/merant/lib/UKasedtc20.so XAOpenString=-NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=<Your install directory>/merant/lib/UKasedtc20.sl XAOpenString=-NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=<Your install directory>/merant/lib/UKasedtc20.so XAOpenString=-NSYBASEDB –A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=<Your install directory>/merant/lib/UKasedtc20.so XAOpenString=-NSYBASEDB –A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
SwitchFile: C:\WMQI\BIN\UKase20.dll
XAOpenString: -NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2
XACloseString:
ThreadOfControl: THREAD
The following examples show what you must include in the XAResourceManager stanza in the qm.ini file on UNIX systems, and the equivalent Windows information. In each example, uid represents the user login and pwd the user ID's password.
XAResourceManager: Name=SYBASEXA SwitchFile=UKasedtc20.so XAOpenString=-NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=UKasedtc20.sl XAOpenString=-NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=UKasedtc20.so XAOpenString=-NSYBASEDB –A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=UKasedtc20.so XAOpenString=-NSYBASEDB –A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
SwitchFile: C:\WMQI\BIN\UKase20.dll
XAOpenString: -NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2
XACloseString:
ThreadOfControl: THREAD
If you want to use Sybase in coordinated transactions, follow the general instructions in the section called "Sybase configuration" in the WebSphere MQ System Administration book, and use these with the instructions given here. WebSphere Message Broker supports only Sybase Version 12_5.
The following examples show what you must include in the XAResourceManager stanza in the qm.ini file on UNIX systems, and the equivalent Windows information. In each example, uid represents the user login and pwd the user ID's password.
XAResourceManager: Name=SYBASEXA SwitchFile=UKasedtc20.so XAOpenString=-NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=UKasedtc20.sl XAOpenString=-NSYBASEDB -A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
XAResourceManager: Name=SYBASEXA SwitchFile=UKasedtc20.so XAOpenString=-NSYBASEDB –A<YourServerName,YourPortNumber> -WWinsock -Uuid -Ppwd -K2 XACloseString= ThreadOfControl=THREAD
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ac00920_ |