What should be the Buffer Size and Timeout under performance in Job Activities?
When two jobs are using the same tables at the same time on execution?
The row buffer is enabled in inter process.
The problem is that when two jobs are using the same tables at the same time one of the job gets aborted and gives the following warning:-
Error in mutex_lock() - Invalid argument
Explain the reason also, if possible.
Buffer size and Timeout
Moderators: chulett, rschirm, roy
-
Raghumreddy
- Participant
- Posts: 24
- Joined: Fri Aug 26, 2005 3:52 pm
- Contact:
You need to do the source stage "Read Only". So that you can eliminate the locks.
Buffters depends on your system memory capacity.
Please ask your Ds admin how much memory is used at the peak and and what are the % of memory used.
You can use multiples of 128's as the buffer sizes.
Most of the times its going to be trial and error.
Increase the size of the buffer until you get the better performance.
Thanks
Raghu
Buffters depends on your system memory capacity.
Please ask your Ds admin how much memory is used at the peak and and what are the % of memory used.
You can use multiples of 128's as the buffer sizes.
Most of the times its going to be trial and error.
Increase the size of the buffer until you get the better performance.
Thanks
Raghu