Pinned topic Array size in an odbc stage in datastage
can anyone explain me in detail about the ARRAY SIZE option in an odbc stage in websphere ?
More typically I want to know the effects on the performance of a parallel job developed,with different array sizes.
SudhakarVediappan 270006DUF61 Post
Re: Array size in an odbc stage in datastage2013-06-11T04:26:04ZThis is the accepted answer. This is the accepted answer.
Array size is the number of rows transferred between DataStage an Oracle at a time. It applies to both input and output. For reading, Oracle will build up the required number of transactions before sending them to DataStage. On output, DataStage will buffer these up before sending them to Oracle. In our situation, DataStage is on the same server as Oracle, so we generally have array size set to 1. However, for Oracle databases on other servers, we generally use a larger value for array size to improve efficiency over the network.