Job running long time

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Job running long time

Post by pandeesh »

hi,

We have a batch job which calls many jobs.
Usually it takes 20 mins to complete.
Each job will take 2 or 3 mins to complete.
This batch will run once in 30 mins in a day.
It used to run fine.
But in some days ,the batch will not finish in 20 minutes and it will run forever.
In one of the job, in the log it says job execution finished OK.
But the status is not returning to the batch job control.
That's why the batch is not completed and waiting for the job to complete.
So, what i will do is i ll manually stop that job and will run again.
But it will through fifo lock error.
So i used to clear the fifo lock and rerun the batch again.
it will complete fine.
But i want to know the rootcause and fix it permanantly.
i am wondering why the job status is not being returned to the jobcontrol even though it's finished.
What could be the reason for this?

Thanks
pandeeswaran
nayanpatra
Participant
Posts: 41
Joined: Sat Jun 06, 2009 11:13 pm
Location: Kolkata

Post by nayanpatra »

Are you updating any batch control table in any database? Then you may check the connection between the datastage and the database. Also check for the file system.
Nayan
Post Reply