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.
DB2 Upsert in too slower to Mulit Partitions
Moderators: chulett, rschirm, roy
Re: DB2 Upsert in too slower to Mulit Partitions
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.
This is caused by DB2 Fix Pack 9.1.5
I downgraded DB2 9.1.5 to 9.1.4
It's solved it.
dhwankim wrote: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.