Can't stop a sequence/job

johnno · Post by **johnno** » Tue Aug 05, 2003 5:35 am

DataStage version 6.

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!

Any suggestions.

spracht · Post by **spracht** » Tue Aug 05, 2003 5:48 am

As you can be sure that the job isn't running anymore, you can do a Job->Clear Status File in director.

Stephan

ariear · Post by **ariear** » Tue Aug 05, 2003 6:01 am

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 !

degraciavg · Post by **degraciavg** » Tue Aug 05, 2003 6:15 am

Hi Johnno,

Please try the following...

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

Hope this helps... [:)]

vladimir

johnno · Post by **johnno** » Tue Aug 05, 2003 7:19 am

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

Help!

ariear · Post by **ariear** » Tue Aug 05, 2003 7:36 am

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

johnno · Post by **johnno** » Tue Aug 05, 2003 9:28 am

Thanks guys. All is well with the world again!