Have a sequence that cntains a DSBasic job that has gone into an infinite loop. Yesterday and today I have sent numerous stop requests (for both the job and the sequence) to the server via Director but nothing happens. We shutdown and restarted the DataStage server this morning but the job is still running!
What stephan is saying is one possibility
The other possibility is that the job is relly still running - Re-starting the DS Server not necessarily kills the running jobs
You need to identify it by user and process name (uvsh) and kill it manually then you be in the state that stephan described !
1. Open DS Director
2. Highlight your job
3. From menu, click Job then Clear Status File
4. If the file still shows "Running", open it in DS Designer and re-compile
Thanks guys. I was attempting to do a Clear Status when I read in the manual that you should ensure that all the job's processes have ended (via the job resources dialog box). When I try to 'show by job' I get the following message:
ERROR: Cannot find any process numbers for stages in job SEL020ManagFileValidationAndLoad
This means that the process no longer exists and you can clear the status file.
You can double check it using OS commands (PS ... on unix/task manager..on windows) look for uvsh with the right user