Refresh in Director very slow

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
chinek
Participant
Posts: 75
Joined: Mon Apr 15, 2002 10:09 pm
Location: Australia

Refresh in Director very slow

Post by chinek »

Hi,
We have just installed v7.5 in a new F15K SUN server (Solaris 2.8)
and 4 CPUs and 8 GB memory.
However in DS Director in a project that has 392 jobs , each time the screen refreshes it takes about 30 seconds whereas in the old server running v5.1 it takes just 3 seconds.

So what gives ? Is the way Director in v7.5 refreshes the screen different than v5.1 ? Is there a way to speed this up because this is very annoying.
I have also extended the refresh rate to every 65 secs but would rather increase that to more.

Can this be extended beyond 65 secs ? Also ideally we would want the refresh to refresh quicker.

Can someone help ?
Thanks.
davidnemirovsky
Participant
Posts: 85
Joined: Fri Jun 04, 2004 2:30 am
Location: Melbourne, Australia
Contact:

Post by davidnemirovsky »

Are your jobs in that project sorted into categories? The more jobs in a category, the longer the refresh takes. Moving jobs into a category does not alter the jobs in any way.

Not sure about the refresh rate being able to be higher than 65 secs.
Cheers,
Dave Nemirovsky
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Refresh in Director very slow

Post by chulett »

chinek wrote:Can this be extended beyond 65 secs ?
No, valid values are 2 - 65 seconds only. Not sure why, that's just the way it is.

Can't say in what way the Director has changed, but I'm sure it has under the covers since the 5.x days. As noted, the best way to speed things up is to minimize the number of items being refreshed at any given time. Simplest way to do that is through the use of Categories. There are also Filters you can apply, which can help at times, but in general the liberal use of categories is best.

Your network speed plays a role as well, but I'm assuming that hasn't changed. FWIW, my largest category currently has 125 jobs in it and it take ~13 seconds to refresh (initially) - at home over VPN. It's quicker when on the network at work and much quicker on subsequent refreshes.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Which view in Director?

Status view needs to refer to the RT_STATUSnnn table for each job in the currently selected category. (Hint: don't have too many jobs per category.)

Log view needs to refer only to the RT_LOGnnn table for the currently selected job, but this may involve a large number of events, and they have to be sorted into timestamp order. (Hint: keep logs as small as possible.)

Schedule view needs to refer to the operating system scheduler (crontab or AT) as well as the RT_STATUSnnn table for each job in the currently selected category.

Monitor view needs to look at each record in the RT_STATUSnnn table for the currently selected job, current wave (and, possibly, current invocation ID), and perhaps RT_CONFIGnnn as well. The same is true if you have "show performance statistics" selected in Designer.

Each refresh runs as an interactive process on the server, saying "give me an update". Since interactive processes have higher priority than background processes, this can negatively impact performance of running jobs.

Prefer not to have Director open when jobs are running. Next best is to keep Director minimized as much as possible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply