Page 1 of 1

different invocation id

Posted: Tue Jun 03, 2014 12:26 am
by iskapalli
Hi,

in production one sequence is running with three differnt invocation ids in production(4 nodes)

I think one job will run and remaining jobs will fail

please confirm that

Posted: Tue Jun 03, 2014 1:05 am
by ray.wurlod
Based on the information you have provided, you are not correct.

All three invocations will run.

The fact that they can have invocation IDs already tells us that they are configured for multi-instance running.

However, the design itself may cause failure. For example, if all three try to write to the same hard-coded file name at the same time, then that will cause a failure.

Posted: Tue Jun 03, 2014 1:26 am
by iskapalli
thanks for your reply

suppose schedule time is 6:30. it is triggering at time (no second different).

even that time also will jobs will run?

Posted: Tue Jun 03, 2014 5:35 am
by ArndW
Multi-instance jobs were implemented in DataStage so that multiple instances of the same job could run at the same time. As Ray stated, if the jobs aren't correctly designed they may still fail. For example, if they write to the same sequential output file at the same time they would deliver incorrect results, but if they write to the same database table at the same time they will function as designed.