Is there a limit to the amount of memory Ascential uses

Sid · Post by **Sid** » 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

ray.wurlod · Post by **ray.wurlod** » 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?

Sid · Post by **Sid** » 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

Sid · Post by **Sid** » Tue Nov 06, 2007 3:27 am

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

ArndW · Post by **ArndW** » 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