Waiting for job to start

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
nisaumande
Participant
Posts: 13
Joined: Fri Aug 11, 2006 11:57 am
Location: Toulouse, France

Waiting for job to start

Post by nisaumande »

Since a few days, our jobs sequence are taking more than one minute to start the job design in our development environment.

Here is the log of one of our job :

2694 INFO ~2006-12-13 11:20:22 JsIntegrationMAPP_FAB_MAPP..JobControl (DSRunJob): Waiting
- for job JcCMNExecuteJobDesign.JaAlimentationT_AXE_UO to
- start
2695 RUNJOB ~2006-12-13 11:21:06 JsIntegrationMAPP_FAB_MAPP ->
- (JcCMNExecuteJobDesign.JaCreationHfT_REF_INDICATEUR): Job
- run requested
- Mode (row/warn limits) = 0/100
- Job Parameters --->
- PNomJob=JdCreationHfT_REF_INDICATEUR
- DSJobController=JsIntegrationMAPP_FAB_MAPP

Would it be a problem of the project needing purge ?

Before deleting and recreating the project, is there any other solution ?

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

Post by chulett »

It could be that your server is just... busier, unless it always seems to take longer to start regardless of what else is going on. That was an issue for us awhile back, one or two runaway processes from another group locked up CPUs for their exclusive use and everyone else's performance went 'in the toilet' as they say. I'd first check for things along those lines with an SA before going with the rather drastic 'purge' of the project. :?

Also check your log file sizes... are they getting out of hand for these jobs? Are they set to auto-purge?
-craig

"You can never have too many knives" -- Logan Nine Fingers
nisaumande
Participant
Posts: 13
Joined: Fri Aug 11, 2006 11:57 am
Location: Toulouse, France

Post by nisaumande »

I checked the cpu use during that 'pause' and it was mainly idle.

We tried to purge the logs for that job before lauching it, the start is still delayed.

The auto-purge is on and keep 3 days of logs.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Try to clear the &PH& folder. See if that helps.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
nisaumande
Participant
Posts: 13
Joined: Fri Aug 11, 2006 11:57 am
Location: Toulouse, France

Post by nisaumande »

I deleted the 10 306 files of the &PH& folder, and it's working much better.

Would it be a good thing to clear that folder automatically every month on each of our environnement ?
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Its a good idea. Search for something like files older than 7 days, and delete them. Search this forum, i think Ray has a piece of code out here to do that.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Sorry Nisa for getting into your tread.

DSGuru,

Can you tell me how to do this when you are working on windows OS?

Thanks
Sam
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I am no dos expert but here is what i found on google. Maybe a batch file expert can throw some more light.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Thanks DSGuru. Anyway i am opening a new thread fo this.

Sam
Post Reply