Page 1 of 1
lookup error - no space left on device
Posted: Fri Aug 20, 2010 1:43 pm
by Marley777
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]
Posted: Fri Aug 20, 2010 1:50 pm
by kris007
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.
Posted: Fri Aug 20, 2010 2:18 pm
by mhester
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.