Perfomance of DB2 stages -- Array size
Posted: Thu Mar 03, 2011 11:34 am
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
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