DSXchange

Hi ,
while carring out migratin from 6 to datastage 7 ,
we ran a job in testing enviroment which is running non stop ie with out finishing or aborting.
Need your suggesion to finish the job successfully.
Thanks
Prashant

Prashant,

you have two problems and have asked two questions in your post - You have a job that is not working correctly and need to figure out why, and you have a process that you want to stop.

Stopping your job should first be attempted by issuing a "stop" request from the director window. Sometimes the process is in a state where it doesn't respond to interrupt requests and you will need to take stronger measures. There are a lot of posts about this type of action on the forum.

The analysis of the reason for your job not running is a bit tougher. Usually your job is either running so slowly that it seems to take forever or somewhere on the job it is waiting for a resource to be freed. You will need to do some work to diagnose the cause. Does the job use CPU or I/O time? Does the log show any rows processed or any warnings/error messages (This includes doing a reset of the job once stopped and checking if there is a "from last run" message). Does the job do anything out of the ordinary?

HI,
You can also check at the stage which it hangs up.
Once we face same sort of issue at load stage. Then we happen to restart the database to go fine.

-Kumar