If i run the job first 10 times there is no time variation in job execution.In same way i run the job for 100 times it takes 10 times extra time.what is the solution for it?

  • Interview Candidate
  • 2
  • 2599

Showing Answers 1 - 2 of 2 Answers

nikhilanshuman

  • Mar 19th, 2010
 

Depends on the runtime environment. Sometimes on the datastage server many processes are running at the same time.  Sometimes the server might be lacking enough resources required for the job. This leads to make the current process of the job wait for other processes to finish which in turn may slow down the job.

After running the job for 100 times, there will be increase in number of records in the table.  This may impact the performance of upsert in target OCI stage of the jobs.

Sometimes the process might go out of memory resulting in "Page Fault".  This can also slow down the jobs.

There can be many other environmental conditions as well...

  Was this answer useful?  Yes

nikhilanshuman

  • Mar 19th, 2010
 

The solution is to check for any bottlenecks.  Try running the job for two or three more times after certain intervals and take performance statistics.  If the performace is still slow then try optimizing the jobs. 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions