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.
performance difference of same job on 2 environments
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
The problem is that only for this particular job , we have this problem. For remaining jobs, there is no much difference.
Regards,
ssunda.