DSXchange

Posted: **Tue Nov 06, 2007 2:55 am**

Hi ,

I have a datastage job that abends after 475,000 data rows .The temp space for the source & target database is around 2GB so tat shouldn't be an issue .

My question is if there is a limit to the amount of memory that datastage uses & if yes then how can it be modified ?

Thanks,
Sid

Posted: **Tue Nov 06, 2007 3:15 am**

There are lots of configurable limits. What stage types are you using? Have you examined tuning buffer sizes?

Posted: **Tue Nov 06, 2007 3:26 am**

hmmm... can u quote some examples ...
well most of the stages that i am using are odbc stages

Posted: **Tue Nov 06, 2007 3:27 am**

how do u change the buffer size ?? Let me give it a try !!

Posted: **Tue Nov 06, 2007 3:46 am**

Sid wrote:...job that abends after 475,000 data rows...

How about posting the error messages?

DSXchange

Is there a limit to the amount of memory Ascential uses

Is there a limit to the amount of memory Ascential uses

Re: Is there a limit to the amount of memory Ascential uses