lookup error - no space left on device

Marley777 · Post by **Marley777** » Fri Aug 20, 2010 1:43 pm

hi, anyone know what may cause this error? Thanks for your help.

LkpUnitLoc,0: Error writing table file "/IBM/InformationServer/Server/Datasets/lookuptable.20100820.hpsx2ca": No space left on device [keylookup/keylookup.C:491]

kris007 · Post by **kris007** » Fri Aug 20, 2010 1:50 pm

The error message says it all. The process is using up all the space. How many records are you reading from the reference lookup? Splitting your job might help you avoid this error if you have multiple lookup stages.

mhester · Post by **mhester** » Fri Aug 20, 2010 2:18 pm

The lookup operator will attempt to use memory and when it cannot use memory it will use scratch as defined in your configuration file. If this fills up then it will move to TMPDIR as defined in the environment and if it is not defined then it will use /tmp on Unix and c:\TMP on windoze.

If you are using "Entire" partitioning then make sure you really need to. Look at the job score to see if the framework is inserting any additional tsort operators.