MQSeries.net :: View topic - 2122

Mariusz Szurnacki · Posted: Tue May 28, 2002 8:06 pm Post subject:

Hi!!!

I'm playing with XA transactions now and I have the following
problem with it: I can't get rid of the MQRC error: 2122 -
MQRC_PARTICIPANT_NOT_AVAILABLE (it's a MQSeries error, all details are given below).

Our environment (HP-UX 11i platform):
- IBM UDB DB2 7.1 (FP6 U481412)
- IBM MQSeries (without DCE, because of performance problems and
it doesn't work with Oracle thread modeling well) (fix U480850)
- IBM WebSphere MQ Integrator 2.1 (fix U482017)
- Oracle9i Enterprise Edition Release 9.0.1.3.0
- Merant ODBC driver (Version 4.00 for UNIX)

Note:
1. Our test environment works fine. All message flows work without any problems until the Coordinated Transaction option is checked.
I prepared a simple message flow that inserts some data into our Oracle database. It works fine. But if I check the Coordinated Transaction option in Properties on Assignments tab in WMQI, then I receive the MQRC_PARTICIPANT_NOT_AVAILABLE error.

2. My broker user has rights to DBA_PENDING_TRANSACTIONS view.

3. My broker user has the CREATE SESSION privilege.

4. XA stanza from my qm.ini file:

XAResourceManager:
Name=orahelios1
SwitchFile=/MQHA/qm2/mqsi/merant/lib/libSwitchOracle.sl
XAOpenString=ORACLE_XA+ACC=P/login/password+sestm=0+threads=TRUE+DB=XAODS
ThreadOfControl=THREAD

Thr second version has specified SQLNET parameter:
XAOpenString=ORACLE_XA+SQLNET=server_name@ORCL9+ACC=P/login/password+sestm=0+threads=TRUE+DB=XAODS

Of cource, there are correct data instead of serve_name, login and password in our qm.ini file.

5. Although I specified LogDir and DbgFl parameters like this:
XAOpenString=ORACLE_XA+ACC=P/login/password+sestm=0+threads=TRUE+DB=XAODS+LogDir=/var/mqm/qmgrs/CRMA_QM+DbgFl=15

I coudn't received log file.

6. There is provided a symbolic link to libclntsh.sl from /usr/lib.

7. My broker user has rights to v$xatrans$ and v$pending_xatrans$ views.

8. The following lines were added to my broker user .profile file:
export ORACLE_HOME=/MQHA/qm2/oracle9i/9i
export ORACLE_SID=ORCL9

These a few lines comes from syslog:
<SYSLOG>
May 23 05:25:53 helios1 WMQIv210[29583]: (CRMA.grupa)[16]BIP2633W: Warning when starting transaction coordinated by MQSeries; MQBEGIN failed: MQCC=1; MQRC=2122; node 'XA_test.SourceQueue'. : CRMA.ed8e4fee-ed00-0000-0080-ec11f09d29bb: /build
/S210_P/src/DataFlowEngine/ImbMqInputNode.cpp: 774: ImbMqInputNode::readQueue: ComIbmMQInputNode: b757b26e-eb00-0000-0080-ec11f09d29bb
</SYSLOG>

And here is an error from MQ:
<MQ>
AMQ7604: The XA resource manager 'OraHelios1' was not available when called for xa_open. The queue manager is continuing without this resource manager.
</MQ>

Info about the 2122 error from MQ docs:
<DOCS>
MQRC_PARTICIPANT_NOT_AVAILABLE
An MQBEGIN call was issued to start a unit of work coordinated by the queue manager, but
one or more of the participating resource managers that had been registered with the queue
manager is not available. As a result, changes to those resources cannot be coordinated by the
queue manager in the unit of work.
This reason code occurs in the following environments: AIX, HP-UX, OS/2, AS/400, Sun
Solaris, Windows NT.
Corrective action: If the application does not require non-MQSeries resources to participate in
the unit of work, this reason code can be ignored. Otherwise consult your system support
programmer to determine why the required resource managers are not available. The resource
manager may have been halted temporarily, or there may be an error in the queue managerâ€™s
configuration file.
</DOCS>

I would be really grateful for any advices.

Best regards,
Mariusz