Page 1 of 1

UVSH.EXE jobs stays active while job aborts in DatSatge

Posted: Mon Jan 15, 2007 2:59 am
by jzijl
Hello,

I have the impression that although my DataStage job has finished due to an abort an USVH.exe job stays active sometimes, not always.

How can I be sure that when a job finishes due to an abort also the USVH.exe jobs come to an end.

At the moment before I start a DataStage job I check whether a USVH.exe job is active. If so, I end that process.

Kind regards,

Jan

Posted: Mon Jan 15, 2007 4:23 am
by ArndW
What kind of an abort did you have? Normally the executable finishes with the job; perhaps the uvsh.exe you see belongs to another process or user. If you have access to the UNIX truss command you could try to trace what the "rogue" uvsh.exe is actually doing.

Posted: Mon Jan 15, 2007 7:21 am
by jzijl
Hi ArndW,

As soon as this situation occurs again I will let you know.

Kind regards,

Jan

Posted: Mon Jan 15, 2007 7:56 am
by kcbland
Sometimes database processes keep a thread active after the job has died. Do "ps -ef |grep phantom" and look for any DSD.StageRun threads active with PPID of 1, these are your orphaned threads and need killing.