DSXchange

Posted: **Wed Feb 17, 2010 2:44 am**

Hi All,

Db2 UDB stage which is running on 1 node and Sequential performing a operation "insert new or update existing one" taking 20 to 25 minutes for
70000 records, can any onle help me to tune the performance.

Thanks
A

Posted: **Wed Feb 17, 2010 4:00 am**

1. Separate the inserts and updates into separate streams.
2. Upgrade to version 8 and prefer DB2 Connector or DB2 Enterprise stage.
3. Execute in parallel mode if possible.

Posted: **Wed Feb 17, 2010 4:43 am**

One question ray -- if DB2 stage operation "update or insert" run in parallel mode doest it impact the data?

Thanks
Ashish

Posted: **Wed Feb 17, 2010 5:16 am**

I think increasing the 'Transaction Size' and 'Array Size' at the Options tab can make it run faster beside the points that Ray has explained.

Regards.

Posted: **Wed Feb 17, 2010 1:25 pm**

API stage does not run in parallel.

DSXchange

DB2 UDB API stage running very slow

DB2 UDB API stage running very slow