Regarding Compilation of job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ksv2584
Participant
Posts: 16
Joined: Wed Nov 10, 2010 6:10 am

Regarding Compilation of job

Post by ksv2584 »

Hi

One of the job in our project is compiling for 30mins , the jobs is not very complicated also

4 lookup stages
6 trasnformers
4 Oracle Connectors
and few other stages

Please suggest how can we reduce the compilation time

Thanks in advance
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Less traffic on the network between engine and client tiers.
More powerful server for engine tier.
Fewer columns in design.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
SURA
Premium Member
Premium Member
Posts: 1229
Joined: Sat Jul 14, 2007 5:16 am
Location: Sydney

Re: Regarding Compilation of job

Post by SURA »

Not sure why the job is taking much time to compile. But you can try the below option.

Copy the stages alone and place it in a new pallet.
Save it as a different name.

Try to compile it.

Let us know how this went!
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Post Reply