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 PostACCEPTED ANSWER
Re: Array size in an odbc stage in datastage2013-06-11T04:26:04Z in response to SystemAdmin
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.