UVSH.EXE jobs stays active while job aborts in DatSatge

[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

[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.

[jzijl]

Hi ArndW,

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

Kind regards,

Jan

[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.