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



Joined: 18 Mar 2004
Posts: 10

Points: 114

Post Posted: Mon Jul 19, 2004 2:46 am Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Server
OS: Windows
Hi All,

Can anybody explain me about the practical advantage of executing multiple instances of DataStage Job. In which scenario I can go for this?

Regards
Prasad
amitdurve
Participant



Joined: 11 May 2004
Posts: 8
Location: bangalore
Points: 42

Post Posted: Mon Jul 19, 2004 2:54 am Reply with quote    Back to top    

Multi instance jobs can be used when say you want to do the same type of processing for multiple input files.
Rather than running the same jobs over and over again you could created routes using which you could process multiple files together.
If you didnt have multi instancing you would have had to make copies of these jobs, now you just call the same multi instance enabled job, just by passing a different invocation id as many times as you like.
Rate this response:  
Not yet rated
bks_prasad
Participant



Joined: 18 Mar 2004
Posts: 10

Points: 114

Post Posted: Mon Jul 19, 2004 4:29 am Reply with quote    Back to top    

Hi,
thank you very much..Now I am able to work on multiple instances

Rgds
Prasad
Rate this response:  
Not yet rated
kcbland

Premium Poster
Participant

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

Joined: 15 Jan 2003
Posts: 5209
Location: Lutz, FL
Points: 39192

Post Posted: Mon Jul 19, 2004 8:51 am Reply with quote    Back to top    

Multiple instances are incredibly useful for partitioning datastreams and using multiple copies of the job to process the data. Why have 1 job crunch the numbers on a 16 cpu system when you can have ...

_________________
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rate this response:  
Not yet rated
rasi
Participant

Group memberships:
Australia Usergroup

Joined: 25 Oct 2002
Posts: 464
Location: Australia, Sydney
Points: 2348

Post Posted: Mon Jul 19, 2004 5:39 pm Reply with quote    Back to top    

Another advantage is that you get separate logs in your director for each instance. This is very useful to check what is the result for each invocation id's.

Thanks
Siva
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: 54551
Location: Sydney, Australia
Points: 295806

Post Posted: Tue Jul 20, 2004 6:02 am Reply with quote    Back to top    

There's actually only one physical log, but you get multiple views (one per invocation) in Director. Purge the log and all the views magically vanish!

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



Group memberships:
Premium Members

Joined: 14 Aug 2003
Posts: 70

Points: 597

Post Posted: Tue Jul 20, 2004 8:22 am Reply with quote    Back to top    

For example, if you want to process data from different geographical areas (time zones) due to volume of data and provide data to users in those areas as soon as you finish. In that case you need to process data using same methodology with different parameters. You can use multiple instances of the jobs or copies of the same jobs. But Multiple instances will give you more flexibility for scheduling etc....

Sree
Rate this response:  
Not yet rated
rakesh.puli



Group memberships:
Premium Members

Joined: 22 Mar 2017
Posts: 13

Points: 137

Post Posted: Wed Jan 08, 2020 7:14 am Reply with quote    Back to top    

Hi

Can a multiple instance job be a file to table load or only a table to table load ?

Thanks
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 43053
Location: Denver, CO
Points: 222300

Post Posted: Wed Jan 08, 2020 8:43 am Reply with quote    Back to top    

There's no restriction of that nature.

_________________
-craig

"May the bridges I burn light my way forward"
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