Hi
The Hashed file Stage , Read Cache size and Write Cache size from DataStage Administrator.... does it specify the max total size it can cache for all hash files in the project OR is it the value of each individual hash file cache size?
Thanks
Tunables in Administrator
Moderators: chulett, rschirm, roy
Re: Tunables in Administrator
arindami wrote:Hi
The Hashed file Stage , Read Cache size and Write Cache size from DataStage Administrator.... does it specify the max total size it can cache for all hash files in the project OR is it the value of each individual hash file cache size?
Thanks
It specify individual hash file size for Read and Write opertaion. In the Designer it self you can individually tune them.
Avishek Mukherjee
Data Integration Architect
Chicago, IL, USA.
Data Integration Architect
Chicago, IL, USA.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That answer is not correct.
The Tunables values are the default (not maximum) size to be used for hashed file cache - not hashed files. What you set in the Administrator is the default value; these can be overridden on a per-job basis using the job properties dialog.
The upper limit is theoretically 1000MB, but is constrained by the spin button control to 999MB. Don't go anywhere near these values unless you actually have the (real) memory to support this much demand.
The Tunables values are the default (not maximum) size to be used for hashed file cache - not hashed files. What you set in the Administrator is the default value; these can be overridden on a per-job basis using the job properties dialog.
The upper limit is theoretically 1000MB, but is constrained by the spin button control to 999MB. Don't go anywhere near these values unless you actually have the (real) memory to support this much demand.
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.
You're mixing up a couple of different things here. The default Row Buffer size can be set in the Administrator and overriden on a per-job basis. The Hashed File Cache setting are not defaults - those are the values used for the entire project. It would be great if they could be overriden at the job level, but they can't.ray.wurlod wrote:The Tunables values are the default (not maximum) size to be used for hashed file cache - not hashed files. What you set in the Administrator is the default value; these can be overridden on a per-job basis using the job properties dialog.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: