Perfomance of DB2 stages -- Array size

[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

[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.