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
How to Increase Buffer Size more than 1024 in a job?
Moderators: chulett, rschirm, roy
How to Increase Buffer Size more than 1024 in a job?
Best Regards,
Jorge Calvo
Jorge Calvo
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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: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 ...
http://etl-tools.info/en/datastage-faq- ... -mutex.htm
Best Regards,
Jorge Calvo
Jorge Calvo
That link states that the buffer size can be increased
...increase the buffer size (up to to 1024K)...
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>