Jobs Got Too Slow Suddenly

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vintipa
Participant
Posts: 136
Joined: Wed May 07, 2008 11:26 am
Location: Sydney, Australia
Contact:

Jobs Got Too Slow Suddenly

Post by vintipa »

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?
Vinay
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Only if you can tell us what changed in the system. Clearly "nothing" is not the correct answer. You have some detective work to do.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply