Hi Friends,
We have datastage installed in one server LPAR and db2 istalled in another LPAR in a Unix pseries machine. this is our production environment. The Jobs which used to run with over 7000 rows/sec speed now have slowed dowm to 1- 100 rows/sec, all of a sudden. There is no space issue in the servers. Servers have enough idle time. yet sometimes jobs loading data from a file to a table and sometimes jobs processing just files become slow.
We have Data Warehouse project and this has affected the delivery of data drastically [:(]. Can somebody tell me the reasons when jobs slow down in this manner?
Jobs Got Too Slow Suddenly
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: