| Author |
Message |
Raa_ONE
Participant
Joined: 14 Sep 2018
Posts: 5
Points: 33
|
|
| DataStage® Release: 11x |
| Job Type: Parallel |
| OS: Windows |
| Additional info: Both windows and unix OS |
|
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
Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group
Joined: 23 Oct 2002
Posts: 54464
Location: Sydney, Australia
Points: 295356
|
|
|
|
|
|
|
How are you loading to target? INSERT, Insert/Update, or bulk load?
|
_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane |
|
|
|
|
Raa_ONE
Participant
Joined: 14 Sep 2018
Posts: 5
Points: 33
|
|
|
|
|
|
|
Consider I'm doing insert and bulk load on two different occasions.
|
|
|
|
|
|
chulett
since January 2006
Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group
Joined: 12 Nov 2002
Posts: 42881
Location: Denver, CO
Points: 221079
|
|
|
|
|
|
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
The Old Ones were, the Old Ones are, and the Old Ones shall be. Not in the spaces we know, but between them. They walk serene and primal, undimensioned and to us unseen.
|
|
|
|
|
qt_ky
Group memberships:
Premium Members
Joined: 03 Aug 2011
Posts: 2850
Location: USA
Points: 21668
|
|
|
|
|
|
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
|
|
|
|
|
|
|
