DB2 Upsert in too slower to Mulit Partitions
Posted: Thu Jul 10, 2008 7:34 pm
Hi All
This week, I have installed DataStage Enterprise Edition on MPP Environment.
after that, I check functionality or performance of DataStage Server , Parallel Job.
My Problem is that
When I upsert data to single partition table.
Row per Second is aroubd 20,000 records.
but When I upsert data to 8 partitions table (same table layout).
Row per Second is around 200 records
I can not guess what is wrong with machines and datastage.
DB2 Version 9.1.5
DataStage 7.5.2
Please give any tip or advise.
Thanks in advance.
This week, I have installed DataStage Enterprise Edition on MPP Environment.
after that, I check functionality or performance of DataStage Server , Parallel Job.
My Problem is that
When I upsert data to single partition table.
Row per Second is aroubd 20,000 records.
but When I upsert data to 8 partitions table (same table layout).
Row per Second is around 200 records
I can not guess what is wrong with machines and datastage.
DB2 Version 9.1.5
DataStage 7.5.2
Please give any tip or advise.
Thanks in advance.