We worked around above issue by replacing lookup by join stage but recently I encountered another issue with a similar job (with lookup) in same environment which confused me:
Earlier message was:
But I am also getting another message from lookup stage in similar job:Could not map table file "/opt/IBM/InformationServer/Server/Datasets/lookuptable.20111207.hezfuxb (size 3938972368 bytes)": Cannot allocate memory
-What is difference in these two messages?Requested memory for table file :"/opt/IBM/InformationServer/Server/Datasets/lookuptable.20120304.p3odhbc" (size 2292096328 bytes) exceeds limit. Please consider using join instead of lookup
- What is limit- is it 4 GB or 2 GB or anything else?
-is it a DataStage limitation or limit imposed by Linux OS?
As stated above , we are using InfoSphere 8.1 FP1 ( 32 bit) with Linux Suse (64 bit)
I am really confused. Any help/guidance will be highly appreciated.
Please let me know if you need more details.
Thanks in Advance.