IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2013-06-11T04:26:04Z by SudhakarVediappan
7754 Posts

Pinned topic Array size in an odbc stage in datastage

‏2009-06-25T05:03:11Z |

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
    1 Post

    Re: Array size in an odbc stage in datastage

    ‏2013-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.