optimizing process for data loading to target

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
Raa_ONE
Participant
Posts: 5
Joined: Fri Sep 14, 2018 10:56 am

optimizing process for data loading to target

Post by Raa_ONE »

How do you optimize the process when your data after performing multiple operations taking a long time to load to target systems.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How are you loading to target? INSERT, Insert/Update, or bulk load?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Raa_ONE
Participant
Posts: 5
Joined: Fri Sep 14, 2018 10:56 am

Post by Raa_ONE »

Consider I'm doing insert and bulk load on two different occasions.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:?

Consider that you've been asking extremely general / hypothetical questions and what we're really all about here is peer-to-peer support of specific issues / problems. I'm not sure how you can expect anything but extremely general answers in return...
-craig

"You can never have too many knives" -- Logan Nine Fingers
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

I think I know the answer...

You look in DataStage Director and click on the Elapsed Time column header to sort and help you find the longest running jobs. Then you can know which ones need performance tuning.
Choose a job you love, and you will never have to work a day in your life. - Confucius
Post Reply