hi
i have approximately 10000 records in a hash file and i am doing a look up on this hash file for populating the target tables.i am getting update for the hash file every 15days.so how can i refesh my hash file so that look up will be effective.i dont want to use ODBC for look up
lookup on hash file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
1. Yes.Dsnew wrote:Ray, When you said "Enable write cache"
Does that mean check the "Allow stage write cache"
Also in a hashed file when do you use - Pre-loadfile to memory?
2. You pre-load a hashed file to memory when the size of the hashed file is low and it greatly improves the performance of a lookup since the hashed file will be in memory and disk I/O is avoided.
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
1. Yes
2. Yes, unless updating the same hashed file in the same job. In which case disable both write and read cache (since they're separate caches). If the hashed file is tiny (say less than 10 groups) I probably wouldn't bother with read cache either, as its pages are likely to be memory resident in any case.
2. Yes, unless updating the same hashed file in the same job. In which case disable both write and read cache (since they're separate caches). If the hashed file is tiny (say less than 10 groups) I probably wouldn't bother with read cache either, as its pages are likely to be memory resident in any case.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.