Job stay in running mode in director

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Job stay in running mode in director

Post by thurmy34 »

Hi gurus
We are facing the following issue: some jobs are staying "running" in the Director.
When we check the monitor all the stages are green and in the log we can see the sequence main program finished "Ok".

On the server a process usvh is present.

What is your advice?

Thank you.
Hope This Helps
Regards
WesL
Premium Member
Premium Member
Posts: 26
Joined: Wed Jun 28, 2006 1:05 pm
Location: Huntsville, AL

Post by WesL »

Happens from time to time. Check out this technote and see if it helps clear up the issue.

http://www-01.ibm.com/support/docview.w ... wg21390366
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The technote seems to be specific to all jobs hanging rather than 'some'...
-craig

"You can never have too many knives" -- Logan Nine Fingers
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Post by thurmy34 »

Hi Wesl

I knew this link , i don't feel confortable running the CLEAR.FILE &PH& command (because it's not clear to me) and like Chulett is't about tree jobs in a project.

Thank you anyway.
Hope This Helps
Regards
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Is it in PROD or a non prod environment where you can play a bit?
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Post by thurmy34 »

it's a non prod environnement
Hope This Helps
Regards
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If you're sure (for example from the log) that the job has finished, clearing its status file from Director will clear the Running status.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Post by thurmy34 »

I'm ok with that Ray but that i really want it's a way to avoid the problem.

Thank you.
Hope This Helps
Regards
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'd still look at the &PH& directory in the project and see if it has "a large number" of entries in it. And when you are at a point where no jobs are (legitimately) running in it, do the CLEAR.FILE mentioned. Keeping it pruned down - assuming there are many files there - is actually one way to avoid problems.
-craig

"You can never have too many knives" -- Logan Nine Fingers
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Post by thurmy34 »

Chulett

In the &PH& i have 436 files (is this large ?).
The creation date of the oldest is 14/10/2013 the date of the newest is today.

Thank you
Hope This Helps
Regards
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I don't believe so... still, clear it and see if the behavior you are seeing changes at all.
-craig

"You can never have too many knives" -- Logan Nine Fingers
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Create a "CopyOf" job, rename the orriginal to "..._bak", rename the CopyOf to the orriginal name, recompile.

See if the issue persists. If it does not, then you can analyze your "_bak" files. If it does, then you have a larger environmental issue and this freeze might be affecting other jobs, but you just don't know it yet.


Do you have any After Job routines on this job that could still be running?
thurmy34
Premium Member
Premium Member
Posts: 198
Joined: Fri Mar 31, 2006 8:27 am
Location: Paris

Post by thurmy34 »

Hi All
We're still facing this issue .
Can you help me ?
Regards
Hope This Helps
Regards
PaulVL
Premium Member
Premium Member
Posts: 1315
Joined: Fri Dec 17, 2010 4:36 pm

Post by PaulVL »

Are you using the grid enablement toolkit?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Have you involved support?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply