How to Increase Buffer Size more than 1024 in a job?

J.Calvo · Post by **J.Calvo** » Thu Oct 15, 2009 9:03 am

Hello,

Other problem that i have found is whitch How i could increase the row buffer size as more than 1024 in the performance properties of a job?

When I set a value greater than 1024 ... automatically it change to 1024..
Why?

Thanks

ray.wurlod · Post by **ray.wurlod** » Thu Oct 15, 2009 3:12 pm

It's not possible. The behaviour you have observed confirms that. You are specifying a 1MB buffer on every link in the job - that should be more than enough for most jobs. Buffers do not fill - they are continually being written to and read from. They simply allow more rows than one at a time to be passed through the job design. It's called "pipeline parallelism".

J.Calvo · Post by **J.Calvo** » Fri Oct 16, 2009 2:07 am

ray.wurlod wrote:It's not possible. The behaviour you have observed confirms that. You are specifying a 1MB buffer on every link in the job - that should be more than enough for most jobs. Buffers do not fill - the ...

But when you look for information about how to fix the problem: time waiting for mutex ... Really recomends to adjust this value greater than 1024... I don't know... I write the link to the page:
http://etl-tools.info/en/datastage-faq- ... -mutex.htm

ArndW · Post by **ArndW** » Fri Oct 16, 2009 3:17 am

That link states that the buffer size can be increased

...increase the buffer size (up to to 1024K)...

J.Calvo · Post by **J.Calvo** » Fri Oct 16, 2009 3:28 am

ArndW wrote:That link states that the buffer size can be increased
...increase the buffer size (up to to 1024K)...
...

Ok sorry!

J.Calvo · Post by **J.Calvo** » Fri Oct 16, 2009 3:29 am

ArndW wrote:That link states that the buffer size can be increased
...increase the buffer size (up to to 1024K)...
...

Ok sorry!