What version of DataStage?
How (and where on disk) hashed files are cached when not in memory is handled in different ways in different releases. For example, in DataStage 4.2 it's configured with the DS_MMAPPATH and DS_MMAPSIZE environment variables.
Somewhere, though, it appears that you are running out of disk space in this location.
If you load the hashed file without caching, you will probably find that it loads completely, albeit not as fast as with caching. Later you can correct the memory (and/or paging space) problem.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
something strange in Hashfile
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This msg is from version 5.x and up. You're using write cache and you exceed the memory limitation. first try with no write cache (it'll take longer) then ask Ascential support if what happens is only the loosing of cache writing ability but the data is still being written o.k. to the hash. (I thing the answear will be - YES)