Page 1 of 1
How to Increase Buffer Size more than 1024 in a job?
Posted: Thu Oct 15, 2009 9:03 am
by J.Calvo
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
Posted: Thu Oct 15, 2009 3:12 pm
by ray.wurlod
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".
Posted: Fri Oct 16, 2009 2:07 am
by J.Calvo
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
Posted: Fri Oct 16, 2009 3:17 am
by ArndW
That link states that the buffer size can be increased
...increase the buffer size (up to to 1024K)...
Posted: Fri Oct 16, 2009 3:28 am
by J.Calvo
ArndW wrote:That link states that the buffer size can be increased
...increase the buffer size (up to to 1024K)...
...
Ok sorry!
Posted: Fri Oct 16, 2009 3:29 am
by J.Calvo
ArndW wrote:That link states that the buffer size can be increased
...increase the buffer size (up to to 1024K)...
...
Ok sorry!