Re: 28 no space on device

Today I have the same problems on Informix Online 5.08 UD1 / Reliant Unix 5.44 B0033. I've set the DBTEMP to a filesystem big enough, but I get the 212 on every time, I run dbimport. It doesn't work. I run a dbimport script. Dbimport.out ended witch a >create index<. I run this original create index row manuelly with dbaccess at it works !!?! Now I have comment the >create index< rows out in this SQL script, and try to create them manuelly after loading tha data. How can I define a temp dbspace for Informix Online, becaus my /tmp is not big enough. MEYER2:/home2/fib01 > DBTEMP=/home2/temp MEYER2:/home2/fib01 > export DBTEMP MEYER2:/home2/fib01 > echo $DBTEMP /home2/temp MEYER2:/home2/fib01 > dfspace / 58,67 MB von 96,32 MB verfuegbar ( 60,92%). /proc 0,00 MB von 0,00 MB verfuegbar (100,00%). /dev/fd 0,00 MB von 0,00 MB verfuegbar (100,00%). /usr 40,35 MB von 200,00 MB verfuegbar ( 20,18%). /var 153,70 MB von 200,00 MB verfuegbar ( 76,85%). /opt 73,05 MB von 300,00 MB verfuegbar ( 24,35%). /home 579,01 MB von 684,00 MB verfuegbar ( 84,65%). /home2 1760,95 MB von 2000,00 MB verfuegbar ( 88,05%). many thanks for any help Hartmut Wieczorek ljanda@checkstop.com schrieb in Nachricht <71cnjn$s9l$1@nnrp1.dejanews.com>... >In article <71asul$oaq$1@news.xmission.com>, > "Rick Pearson" <rick@telesell.com.au> wrote: >> >> I've had exactly the same problems on 5.06. The issue here was amount of >> free space in the /tmp directory as the index entries were being sorted >> prior to creation of the index. I managed to get around this by setting the >> DBTEMP environment variable to a device with the necessary free space for >> the creation of the index. >> >> You may want to look into this. I don't know whether it applies to 7.22, >> but it certainly helped me with 5.06. >> >> Rick Pearson >> >> -----Original Message----- >> From: owner-informix-list@iiug.org >> [mailto:owner-informix-list@iiug.org]On Behalf Of WF Software >> Sent: Friday, 30 October 1998 6:16 >> To: informix-list@iiug.org >> Subject: Re: 28 no space on device >> >> In article <71a1tr$60h$1@nnrp1.dejanews.com>, ljanda@checkstop.com () >> wrote: >> >> > I have version 7.22 on SCO 5.04 >> > and successfully loaded a 16,000,000 row table and >> > created a cluster primary index. >> > >> > When I try to create a secondary index, I get >> > 212 cannot add index >> > 28 no space left on device. >> > >> > I have 4 chunks with 60901, 370509, 414997, and 249997 pages free. >> > >> > This should be enough free space. Any suggestions? Thanks >> > >> > -----------== Posted via Deja News, The Discussion Network ==---------- >> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own >> > >> > >> How big is your next extent and does that blow the dbspace >> >> Paul Watson # I don't suffer from >> WF Software Ltd. # stress, I'm just >> Tel. (+44) 1436 674729 # a carrier >> Fax. (+44) 1436 678693 # >> www.wfsoftware.co.uk >> >> >Rick you are right. I checked the /tmp and sure enough that is it. Although >the DBTEMP does not work. In this version you have to define a temp >dbspace or else it will then use /tmp. >Thanks a bunch > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own