Search found 1 match
- Wed Apr 15, 2009 1:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Peformance issue in parellel job while writing to DB2 stage.
- Replies: 4
- Views: 2499
Peformance issue in parellel job while writing to DB2 stage.
Hi, I am facing with problem analyzing the time taken by one job which has 2 lookups one sort, one aggregator and few transformer stage. This job is taking 1hrs 30 min to complete (for processing 85000 rows). I have the following observations : 1> All the lookups and source query is taking less than...