Hash file size exceeds cache size

tsnmurthy · Post by **tsnmurthy** » Tue Sep 19, 2006 12:23 am

Dear All,

The log says that the 'Hash file size exceeds cache size'. i am using this hash file to check the 'Change Reord Capture' (CRC). due to this hash file size exceeds issue the update hash job is 'Aborted'. To avoid this, we need to increase the cache size for this hash file.

Kindly suggest me,
1) How to Analyze details for a hash file in DataStage Administrator?
2) How we can increase catche size for a hash file?

Advance thanks for all

ray.wurlod · Post by **ray.wurlod** » Tue Sep 19, 2006 12:39 am

(1) ANALYZE.FILE hashedfilename STATISTICS
(2) Tunables tab

The terminology is "hashed file", not "hash file".

You may need to perform a SETFILE command to establish a VOC pointer before ANALYZE.FILE command will work.

kduke · Post by **kduke** » Tue Sep 19, 2006 7:31 am

The cache size is controlled in the DataStage Adminitrator. It is a property of a project. If you exceed the size then you need to reduce the amount of data you put in a hashed file or change this property.

You can reduce the amount of data by only having columns you need. So eliminate unnecessary columns. Most people put columns in the hashed file they never use.

Xpert · Post by **Xpert** » Tue Sep 19, 2006 11:04 pm

ray.wurlod wrote:(1) ANALYZE.FILE hashedfilename STATISTICS

Hi Ray,

Did this command, works for Type -25(B-Tree).

ray.wurlod · Post by **ray.wurlod** » Wed Sep 20, 2006 12:59 am

No.

Type 25 files should only be used for indexes. They do not use a cache. Ever.

There are other utilities for examining Type 25 files, such as blook, but I am not going to pursue that course of inquiry, since it's totally irrelevant for DataStage.