Hi all
this topic may be a little more than only datastage
I am trying to tune a job that calculate check sum on one of our table. The table is massive, it has over 120 million rows in it and more than 60 fields.
the job call a checksum stage to calculate checksum value for each record.
the problem is this job takes too long. more than 2 hours, is there a way to tune this job make it run faster?
thanks
tuning a massive checksum job
Moderators: chulett, rschirm, roy
Can you provide some more details about the job?
What are the source and targets?
Are you reading from the database in parallel?
What else is the job doing if anything?
In the checksum what options do you have selected?
How is the job partitioned?
How large is a row in the table?
How have you determined that the checksum is the cause of the perceived poor performance?
What are the source and targets?
Are you reading from the database in parallel?
What else is the job doing if anything?
In the checksum what options do you have selected?
How is the job partitioned?
How large is a row in the table?
How have you determined that the checksum is the cause of the perceived poor performance?