Lookup Failure - Not enough space/ Error finalizing

[sigma]

Hi


I am getting the following error message

BSISLkup,0: Could not map table file "/usr/IBM/InformationServer/Server/Datasets/lookuptable.20090204.wjqwela (size 3903356896 bytes)": Not enough space
BSISLkup,0: Error finalizing / saving table /tmp/dynLUT311374819e6bad

I read the forum for AIX related issue and found a topic about running the command

usr/ccs/bin/ldedit -bmaxdata:0x80000000/dsa osh

But I need help in knowing where the osh executable or path is

Also Is this simple unix command I run... do I need to restart the engine, or restart the client or is this a uv command I need to execute

Pardon for the basic question but wanted to clarify

Arvind

[ray.wurlod]

You don't need to worry about the osh executable just yet. Your problem was that the file system on which "/usr/IBM/InformationServer/Server/Datasets" resides ran out of space when populating the reference data set. You need your resource disk to include (possibly more directories yielding) more space.

[sigma]

Thanks Ray

I followed up on your advice and I am not sure now

Based on the output below I still have 18.6 gb space available on that mount

Also I am reading a flat file with about 5 million rows. That is my reference link to the lookup. What does it copy that again somewhere in the dataset folder

Please advice. Thanks in advance




df -g output below

df -g
Filesystem GB blocks Free %Used Iused %Iused Mounted on
/dev/hd4 0.25 0.17 33% 3593 9% /
/dev/hd2 2.50 0.63 75% 43894 22% /usr
/dev/hd9var 0.25 0.17 31% 483 2% /var
/dev/hd3 2.75 0.80 72% 7901 5% /tmp
/dev/hd1 0.25 0.25 2% 236 1% /home
/proc - - - - - /proc
/dev/hd10opt 1.75 1.21 32% 8691 3% /opt
<b>/dev/usribm 30.00 18.60 38% 61096 2% /usr/IBM</b>
/dev/cdwdatadev 5.00 4.18 17% 319 1% /cdwdata/dev
/dev/db2v9 4.00 3.55 12% 3748 1% /usr/IBM/db2/V9
/dev/db2inst1lv 6.62 2.86 57% 601 1% /home/db2inst1
/dev/db2v9redo 5.00 2.95 42% 132 1% /usr/IBM/db2/V9/redo
/dev/db2v9data 30.00 26.36 13% 152 1% /usr/IBM/db2/V9/data
/dev/intflv 2.00 1.33 34% 461 1% /intf
/dev/oraclelv 4.00 1.29 68% 14323 5% /oracle
sapstn:/admintools 28.34 2.59 91% 58499 9% /admintools
sapstn:/installdvd 399.00 54.21 87% 222540 2% /installdvd

[ray.wurlod]

What you have NOW is irrelevant. What you have when the job is running is what's important. And the error message suggests that what you have now is insufficient for what you need then.