What happens when size increase in a Hash file

sunshine · Post by **sunshine** » Thu Mar 09, 2006 3:14 pm

Hi,

What happens to a Hash file,when size is increased?

lets say i am transfering data from database to a Hash file.

I came to know from DSXchange forum that maximum allowable for a Hash file is 2 GB.

Can someone explain in more in detail....

Thanks

sunshine

sunshine · Post by **sunshine** » Thu Mar 09, 2006 3:17 pm

what happens when size of a Hash file increases?

gateleys · Post by **gateleys** » Thu Mar 09, 2006 3:20 pm

Kenneth and Ray have provided their suggestions into this. Follow THIS LINK to a previous post.

sunshine · Post by **sunshine** » Thu Mar 09, 2006 3:34 pm

what happens when size of a Hash file increases?

kcbland · Post by **kcbland** » Thu Mar 09, 2006 3:38 pm

A recent DSX newsletter contained a white paper on hashed files. Check it out.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 09, 2006 5:10 pm

sunshine wrote:what happens when size of a Hash file increases?

It gets larger.

If there's free space within its structure that's consumed. After that, it either grows by adding pages (dynamic hashed file) or by extending groups into overflow.

If it's a 32-bit hashed file, the write that tries to take it beyond 2GB will cause internal corruption.

If you've been monitoring its size, and pre-sized it to use 64-bit internal addressing, then the write that tries to take it beyond the largest file the operating system can handle (governed by the O/S itself and your ulimit setting) will cause internal corruption. However, this figure is around 1-19 million TB, so isn't likely to be a problem any time soon.

And, it's "hashed" file, not "hash" file.

DSXchange