Sequence Taking Longer time to Completion
Posted: Sun Mar 01, 2009 3:10 am
Hi,
We have Single Set of Interface Jobs around 100 jobs in a sequence. When run for each country Individually it is taking only 20 min to Completion of Entire sequence. But when we are scheduling 2 or 3 countries it is taking 6-8 hours for completion.
Observations while running 3 countries at same time:
1. No Individual Jobs in Sequence is taking less than 30 Secs for Execution
2. In Sequence beteen two job Activities based on output link trigger conditions, it is taking 4-5 Mins
3. Virun Scanning is running on Server ,Which is scanning all the datastage EXE (uvsh.exe) files generated
4. Virus scanning is also running on Datastage Folders continously while Inerface is running
5. As Datastage is file based system, Internal reference files generated is continously scaned.
Can anyone please tell me what could be probable reason for sequence taking longer time to complete.
If Virus scanning is going on Datastage folders or process does this have any impact on Job execution and causing sequence to Execute slowly.
We have Single Set of Interface Jobs around 100 jobs in a sequence. When run for each country Individually it is taking only 20 min to Completion of Entire sequence. But when we are scheduling 2 or 3 countries it is taking 6-8 hours for completion.
Observations while running 3 countries at same time:
1. No Individual Jobs in Sequence is taking less than 30 Secs for Execution
2. In Sequence beteen two job Activities based on output link trigger conditions, it is taking 4-5 Mins
3. Virun Scanning is running on Server ,Which is scanning all the datastage EXE (uvsh.exe) files generated
4. Virus scanning is also running on Datastage Folders continously while Inerface is running
5. As Datastage is file based system, Internal reference files generated is continously scaned.
Can anyone please tell me what could be probable reason for sequence taking longer time to complete.
If Virus scanning is going on Datastage folders or process does this have any impact on Job execution and causing sequence to Execute slowly.