Execution Order

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Though it seems that the first always get executed first, it may not be sure which will end first. Because both were constructed paralle.
Since the generated code should be in sequence, the first one may seems to kick of first, but the execution will not be same as the start.
If you want to maintain the order desperatly, split the job or redesign in sequence.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

In both server and px jobs your job design would have two independant streams kicked off. If you've found that one gets executed before another it could only be by milliseconds (on a fast machine); for all intents and purposes the OraStage1 and OraStage2 will get started in parallel. In an EE job you will also get {n} concurrent processes kicked off for each stream depending on your apt_config_file node settings at runtime (and also dependant upon your Oracle database partitioning).
williamswe
Participant
Posts: 11
Joined: Mon Dec 05, 2005 4:11 am

Post by williamswe »

Thanks for amost instant replies :o

After monitoring the job run for a few rounds....i found that the order is almost random.

thx for explanation.
Post Reply