Hashed Pre-Load: both DATA.30 and OVER.30?

datastage · Post by **datastage** » Tue Aug 06, 2013 8:26 am

When a hashed file is pre-loaded to memory, is just the DATA.30 loaded or is the OVER.30 included as well?

ArndW · Post by **ArndW** » Tue Aug 06, 2013 10:03 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 06, 2013 4:43 pm

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.