Re: 28 no space on device

In article <363b8fbb.0@news.uni-X.net>, Hartmut Wieczorek <hwieczorek@meyermeyer.de> writes >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. Try also setting PSORT_DBTEMP (??), index builds involves sorting and this controls where sort files go.. >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. > tbspaces with a -t option or set TEMP=Y in tbmonitor when you create it. >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 > > > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care