Hashed files greater than 2Gb

tiagogen · Post by **tiagogen** » Thu May 18, 2006 10:46 am

Anyone knows if there's a problem if my hashed file is greater than 2GB?

I hear something about it... Is it true? Or i can create hashed of any length...

DSguru2B · Post by **DSguru2B** » Thu May 18, 2006 10:55 am

No. There is a limitation in DS for hashed files. That limit is 2.2 GB.
That is because the Hashed file is created by a 32 bit pointer. You can change that to a 64 bit pointer to remove the 2.2 GB barrier.
Look at this post for a start.

Bryceson · Post by **Bryceson** » Thu May 18, 2006 10:55 am

By default DataStage Hashed File are 32BIT and House data up 2.2GB. If your data is more than 2.2GB you will need to create a 64BIT Hash.

Bryceson

tiagogen · Post by **tiagogen** » Thu May 18, 2006 10:59 am

Thanks!

kris007 · Post by **kris007** » Thu May 18, 2006 11:23 am

You can also check this post too.

viewtopic.php?t=92644

Kris.