Hash File Limit

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
suryapkakani
Participant
Posts: 47
Joined: Wed Aug 20, 2008 7:31 am
Location: New jersey

Hash File Limit

Post by suryapkakani »

Hi All,

I have two files that in the range of 3 GB to 5 GB. We have used hash files for having the facts implemented. The performance of job is really slow. I know that we have the limitation of 2.2 GB on a hash file. What are the things that I can do apart from a hash file that can really help in increasing the performance of the jobs.
sunny
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Actually, the 2.2GB limit is for 32bit hashed files, creating them with the -64BIT option effectively removes that limit. Sometimes a lookup can be replaced by a join in a database, perhaps that is an alternative for you?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”