• 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


    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.