Hi All,
I would like to know about arrays in DataStage. ( source and targets stages). Is there any limit depends on system config, or it depends on configuring DataStage?
If it is the case, where can i configure these settings. Every time i am running out of memory if i use array size over 100000 - 300000...
Memory allocation problems. Most of the time, OCI, DB2 drivers are returning these errors.
Please suggest me in right way...
Array size
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 37
- Joined: Sun Aug 01, 2004 1:18 am
Array size
Thanks,
Cnu
We work together to workout...
Cnu
We work together to workout...
The size you choose for your array is dependant upon your allocated DB/2 buffer size. I think that this is 4096 Bytes, the array size should be computed by the following formula INT(<DB Buffer Size>/<record width>). Choosing your array sizes of 100,000 is guaranteed to provide some incredibly slow performance. More common are values lower than 100.
-
- Participant
- Posts: 37
- Joined: Sun Aug 01, 2004 1:18 am
Increase array size
Actually i am using DRS stage, which is used in EPM project (PeopleSoft). How can i increase array size to my requirement. Please let me know where can i do this... what i need to doArndW wrote:The size you choose for your array is dependant upon your allocated DB/2 buffer size. I think that this is 4096 Bytes, the array size should be computed by the following formula INT(<DB Buffer Size>/<record width>). Choosing your array sizes of 100,000 is guaranteed to provide some incredibly slow performance. More common are values lower than 100.
Thanks,
Cnu
We work together to workout...
Cnu
We work together to workout...