Page 1 of 1
Hashed Pre-Load: both DATA.30 and OVER.30?
Posted: Tue Aug 06, 2013 8:26 am
by datastage
When a hashed file is pre-loaded to memory, is just the DATA.30 loaded or is the OVER.30 included as well?
Posted: Tue Aug 06, 2013 10:03 am
by ArndW
Both. They are interrelated and always belong together. These 2 files exist for dynamic (type 30) hashed file. A static hashed file has just one file.
Posted: Tue Aug 06, 2013 4:43 pm
by ray.wurlod
OVER.30 stores overflowed groups and large records. DATA.30 stores the primary buffer of each group. As Arnd notes, both are required; the contents of both are loaded to/from memory where memory caching is used.