DB2 Upsert in too slower to Mulit Partitions

[dhwankim]

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.

[dhwankim]

I found out the problem.
This is caused by DB2 Fix Pack 9.1.5

I downgraded DB2 9.1.5 to 9.1.4
It's solved it.

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.