DSXchange

Hi All,

We have 2 servers with datastage installed on both. A particular job is showing huge difference in performance (time) from one server to the other one. As both servers are different, it might be normal to have difference in job completion time because of properties but for other jobs there is not much difference.

Only for this particular job, on 1st server it is taking 18 minutes and on the 2nd server 8 hours.

The job design is as follows:
Oracle stage -> Change Capture stage (with before data from another oracle table) -> Lookup stage -> transformer -> target oracle table.

Properties like keys, index on tables are same on both servers.
Data from source is around 7 lakhs and from before dataset(table) is 9 lakhs

Please provide some pointers on why there is huge difference in job completion time.

Regards,
ssunda.

What is different between the two servers? "Nothing" is not the correct answer.

I dont know the differences between the 2 servers. Whenever we complete development on 1st server, for testing purpose we move to the 2nd server. (The job is taking more time on 1st server).

The problem is that only for this particular job , we have this problem. For remaining jobs, there is no much difference.

Regards,
ssunda.

Is the data being processed the same on both servers?

Yes. The data is same.

ssunda6 wrote:Yes. The data is same.

If all else is the same, I would have your DBAs import the stats from the one database into the other.