Jobs Got Too Slow Suddenly
Posted: Thu Dec 18, 2008 3:52 am
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?
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?