tuning a massive checksum job
Posted: Thu Nov 16, 2017 6:01 pm
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
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