DB2 UDB API stage running very slow

Ashish · Post by **Ashish** » 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

ray.wurlod · Post by **ray.wurlod** » 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.

Ashish · Post by **Ashish** » 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

sohasaid · Post by **sohasaid** » 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.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 17, 2010 1:25 pm

API stage does not run in parallel.