Improving Sequence Compilation times

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

Moderators: chulett, rschirm, roy

SIHM
Premium Member
Premium Member
Posts: 52
Joined: Fri Oct 18, 2013 3:56 am

Post by SIHM »

The project has been reindexed and the compilation times have been cut in half.

Still awaiting the report from IBM about other things to do.

The server is offsite so cannot get closer to it
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

Often times when the server is very remote (i.e. high network latency), the best option is to stand up remote Windows desktops for the Client tier, in the same data center / on the same remote network as the server. Remote desktop into those machines to do all your client work.
Choose a job you love, and you will never have to work a day in your life. - Confucius
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Right... that or something like a Citrix Server.
-craig

"You can never have too many knives" -- Logan Nine Fingers
SIHM
Premium Member
Premium Member
Posts: 52
Joined: Fri Oct 18, 2013 3:56 am

Post by SIHM »

The response from IBM was to reduce the number of objects in the Job Sequence. The only optimization that can be done is for compilation of PX jobs.

Whilst I'm sure that Citrixing into the machine is a solution, its not one offered here.

I'm closing this as a workaround as there seems to be no magic bullet to solve this.
Post Reply