DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
basav_ds
Participant



Joined: 11 Nov 2007
Posts: 24
Location: Mumbai
Points: 277

Post Posted: Fri Mar 07, 2008 8:11 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi,

I have built two identical jobs consisting of MQ stage, one is Server job and other one is Parallel.

The job consists of, MQ stage which reads xml msgs from Q for infinite period(Wait time=-1). Then these are inputted to XML i/p stage where it breaks down the XML into data elements and inserts those records into Tgt DB2 table using DB2API stage(Transaction size=1, so that commit happens after each record is read).

In server job, the msgs put on the Q(both before job start and after the job start) are immediately inserted into the target table and are visible upon querying the table.

But in parallel job,the issue is, even though the records are read from Q immediately, they are not getting inserted into Tgt Table.

Plz suggest your solutions..

Thank You.

_________________
I never let school to interfere in my education
ArndW

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 16 Nov 2004
Posts: 16318
Location: Germany
Points: 92566

Post Posted: Fri Mar 07, 2008 10:51 am Reply with quote    Back to top    

If you change your parallel job output to a text file or peek stage do you see any rows there? What stage did you use in the Parallel job, and are you certain you set the commit to 1?

_________________

Image
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54594
Location: Sydney, Australia
Points: 296048

Post Posted: Fri Mar 07, 2008 5:18 pm Reply with quote    Back to top    

I don't believe we have a member called Plz.
Rolling Eyes

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
bman
Participant



Joined: 10 Oct 2007
Posts: 33

Points: 397

Post Posted: Fri Mar 07, 2008 5:31 pm Reply with quote    Back to top    

Somewhat similiar to the issue I have with my real time MQ interface. You can try setting the End of Wave to After and see. It should work or atleast it worked for me when I have a direct flow ( I mean no branching out ) after MQ stage till the database

I came accross this bolg from ernie on the real time MQ integration. It might help you here
http://dsrealtime.wordpress.com/category/mq
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours