Hi,
Can anyone please help me out in solving the performance issue in the my job structure.
I have a big problem in extracting 30milion records from sysbase server and load it into the target database which is db2.
The datastage is on AIX server and we are using server jobs.
Can anyone suggest me how to increase the performance of extraction and loading. Present time taken is about 12hrs.
FYI there are inserts and updates in the target database.
Thanks a lot in advance.
Ascential Datastage 7.5 Server Job Performance Issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 22
- Joined: Wed Sep 17, 2003 12:21 pm
- Location: Sydney
As noted, you first need to determine the bottleneck. Split the job, land the data. Tune both halves individually. Use a hashed file to determine inserts v. updates. Consider a bulk loader for the inserts and possibly the updates as well.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers