Startup Time is More

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
Nagac
Premium Member
Premium Member
Posts: 127
Joined: Tue Mar 29, 2011 11:39 am
Location: India

Startup Time is More

Post by Nagac »

Hi

I have One Parallel Job which takes around 8 mins startup time which is reading the dataset, two a shared containers one will do the Key Translation, one will write exceptions and writes into Dataset.

Similar kind of Parallel Job just takes 40Secs Startup time(uses same Shared Containers)

Can you please suggest to reduce the Startup time?

Thanks
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

It could be due to this known issue. If so, install the patch.

viewtopic.php?t=152133
Choose a job you love, and you will never have to work a day in your life. - Confucius
Nagac
Premium Member
Premium Member
Posts: 127
Joined: Tue Mar 29, 2011 11:39 am
Location: India

Post by Nagac »

Not exactly....

I am building brand New Jobs in 9.1. as I mentioned few jobs startup time is very less (<5secs) which uses the same Same Parallel Shared Container.

I have tested on job by removing the Funnel Stage the Startup time was decreased to half not sure what it was doing previously

My Job design is as below

Code: Select all

Seq. Stage--->Transformer--->ODBC Connector
    |                               |
Rejects--->Shared Container<---Rejects
Thanks
vibwipro
Participant
Posts: 40
Joined: Thu Jan 24, 2013 7:34 am

Re: Startup Time is More

Post by vibwipro »

Use Monitor Tab over concerned job to verify which stage is taking more time, then it can help u in analyzing logic's implemented.
Post Reply