DSXchange

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]

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.

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.

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.