hi ,
I am trying to create a LkP Fs..with about 21 million records..each of 36 bytes ..and my Job aborts saying that it has ran out of space after inserting 14 million records..now the resource space has about 254 GB free..
..the exact error msg is :
lkpfsWFccsiCISLPIDxref,0: Could not map table file "/opt/etl/staging/mad/resource/dataset/dataset1/lookuptable.20040923.cgqqvoa (size 1238384552 bytes)": Not enough space.
..any ideas ??
Thanks
LookupFileSet size issue..
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Fri Apr 09, 2004 7:06 pm
Hi Kura,
You may be exceeding the file size limitation on the OS. Find out the max file size on your OS. Then divide that by the size of records and that will give you the size of the max file size. You may have to partiition the job as well. So that the file is within the OS limit.
Thanks
Chaitanya
You may be exceeding the file size limitation on the OS. Find out the max file size on your OS. Then divide that by the size of records and that will give you the size of the max file size. You may have to partiition the job as well. So that the file is within the OS limit.
Thanks
Chaitanya