Poor Server Job Performance
Posted: Thu Sep 04, 2008 1:08 pm
Hi All,
We are seeing consistently poor performance in our server jobs loading to DRS stages. Our database is db2. Poor performance is defined as ~25-500 rows/sec depending on table size. We manage 3 other environments and all perform much better. Of course, datastage is being blamed for not being configured properly, but our configuration is consistent across our environments. I've tried to isolate the problem and have generally found that reading from database to sequential file gives us good performance and that writing to the database is the holdup. I've also found that using link partitioner and multiple links on update statements dramatically increases our performance. However, trying the same strategy on inserts results in extremely slow performance or jobs failing due to what appears to be locking issues.
Anyone have ideas as to what can be holding us back?
We are seeing consistently poor performance in our server jobs loading to DRS stages. Our database is db2. Poor performance is defined as ~25-500 rows/sec depending on table size. We manage 3 other environments and all perform much better. Of course, datastage is being blamed for not being configured properly, but our configuration is consistent across our environments. I've tried to isolate the problem and have generally found that reading from database to sequential file gives us good performance and that writing to the database is the holdup. I've also found that using link partitioner and multiple links on update statements dramatically increases our performance. However, trying the same strategy on inserts results in extremely slow performance or jobs failing due to what appears to be locking issues.
Anyone have ideas as to what can be holding us back?