DSXchange

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

(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.

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.

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

Hi Ray,

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

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.