RE: 28 no space on device

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