Page 1 of 1

Perfomance of DB2 stages -- Array size

Posted: Thu Mar 03, 2011 11:34 am
by chandra.shekhar@tcs.com
Hi All,

Could any one please explain the significance of various parameters available in different DB2 Source/Target stages and how they improve the performance of the job.

For example :

In ODBC Enterprise Stage

1) Insert Array Size
2) Row Commit Level
3) Isolation Level

In DB2 Connector Stage

1) Transaction Record Count
2) Array Size
3) Isolation Level
4) Auto Commit Mode

Thanks & Regards
Srinivas Tanneeru

Posted: Thu Mar 03, 2011 3:20 pm
by ray.wurlod
Welcome aboard.

Start by clicking on Help when in these stage types, or consulting the manual, or visiting the IBM Information Center.

A Search of DSXchange may well prove fruitful too.

Once you have acquired this knowledge, please revert with any particular questions.