Datastage job running infinitely

SachinCho · Post by **SachinCho** » Tue Mar 16, 2010 10:24 am

Hi,
We have one datastage job which is running fine in one environment. When we migrated the same job to QA environment it is running endlessly.

What could be various reasons for such behaviour.

Job design involves a copy stage from which no records are flowing in subsequent stages.

Also there is a sequential file stage which is showing zero records in datastage director monitor.[/code]

ArndW · Post by **ArndW** » Tue Mar 16, 2010 10:32 am

Check from UNIX to see if the job still has processes running, try 'ps -ef | grep {jobname}'. If not, then the job has aborted but the status hasn't been updated. The numbers displayed in the job monitor are not necessarily correct while the job is running, so the 0 records in links aren't always correct.

SachinCho · Post by **SachinCho** » Tue Mar 16, 2010 10:37 am

We have email mechanism which send emails on completion or failure. We are not getting any such emails.
Plus this job is running since more than 24 hours now.

priyadarshikunal · Post by **priyadarshikunal** » Tue Mar 16, 2010 10:47 am

In first post you are talking about a datastage job and in next you mentioned email mechanism. Please perform the checks Arnd suggested and describe the design.