Re: DBIMPORT Error

I missed the first part of the thread but this smells a bit like a tempory files directory is on a file system which fills. SE defaults to putting any temporary tables on /tmp unless you set the environment variable to point somewhere else. Sorry I dont have a manual to hand but the variable is listed in it. In article <31ACFB39.2022@systems.dhl.com> vlulla@systems.dhl.com "Vikram" writes: > First of all, let me thank all of you who responded to my earlier > email. It helped a lot. > > But now I am stuck with a different error after about > 50 tables are created. > > I have a dbexport of a database xyz which was taken as : > > dbexport xyz > > Informix as well as the 'xyz' application are maintained on > another disk - disk2 (not root) > > However when I do the dbimport as : > > dbimport xyz > > the script runs well - it creates the database xyz and about 50 > tables (loads them with data as well) but then gives an error > while creating an index for one of the tables as : > > /: write failed, file system is full > *** execute sqlobj > 212 - Cannot add index. > > 28 - No space left on device > > Please advise as to what parameters need to set/changed inorder to > overcome this problem ( I had increased the dbspace and tried also > but it failed again ) > > Also, I was wondering why it is looking for space on / rather than on > disk2 ?? > > Thanks in advance > -- Gill How Buonacorsi Consulting Limited