Re: DBIMPORT Error

In article <31ACFB39.2022@systems.dhl.com>, Vikram <vlulla@systems.dhl.com> says: > >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 > This may be because the index is using temporary space in /tmp and it is not mounted as a seperate file system I am sorry but I missed your ealier problem what engine are you using ? Perhaps setting DBSPACETEMP or DBTEMP may help the problem These environment variables are explained in the Informix manuals Regards Terry Boyland