Hi,
I am trying to use DTS stage to load data into oracle table while reading messages through MQ Connector stage.
Below is my job design
MQ Connector---->XML Stage---->DTS stage
In DTS stage i am using oracle connector and specified a work queue , In MQ I am using MQ read mode as 'Move to work queue' and Work Queue name has ben specified.
I am able to compile the job successfully and when i run the job all the messages from the actual queue are being moved to work queue, but nothing is being inserted into oracle table and the job fails with below error
Distributed_Transaction_Test,0: Failed to open MQ server library, dlopen() method call failed with error code: 2, error message: 'No such file or directory'
Can some one please help with out with this error message.
DTS stage error
Moderators: chulett, rschirm, roy
DTS stage error
Thanks
Sheema
Sheema
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Re: DTS stage error
Is this the first time that this DataStage server and the queue manager have been used for XA processing?
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
-
- Participant
- Posts: 91
- Joined: Wed Apr 20, 2005 7:59 pm
- Location: U.S.
We have used data stage and MQ combination by reading messages from queue and directly loading them into Oracle by using oracle entrprise stage.
And that job is running fine with out issues. But i saw that DTS is the way to go when we are reading from MQ,so i am trying to use DTS stage.
I am using this field WSMQ.MSGID from Source and moving it to target in DTS stage.
And that job is running fine with out issues. But i saw that DTS is the way to go when we are reading from MQ,so i am trying to use DTS stage.
I am using this field WSMQ.MSGID from Source and moving it to target in DTS stage.
Thanks
Sheema
Sheema
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
XA transactions take a little bit of set up to get working. First, MQ Server must be installed on the DataStage box. If it is, then I'm guessing that you missed the setup of the Oracle switch file and definition of the XA resource manager in the queue manager. Here is the documentation on how to set it up for Oracle:
http://publib.boulder.ibm.com/infocente ... 1650037E19
http://publib.boulder.ibm.com/infocente ... 1650037E19
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com