DSXchange

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

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.

The settings are for each Hashed file that will be used in a job.
The default hashed file size is 2GB and the modulo can be increased by the unix admin preferably.

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.

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.

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.

True, too true. Just got out of bed early Saturday morning. You know how it is.

Yes, I do. Be in the same spot not all that many hours from now.