Re: dbimport

Post your onstat -d output and the dbimport commandline you used.. Art S. Kagel ----- Original Message ----- From: Anders Beng.... <anders.bengtsson@hkv.mil.se> At: 6/26 7:28 > I am on informix 7.3 > > I have dumped my database with dbexport > Then I changed the name of tempdspace to tempdbspace1 and created a new one > called tempdbspace2. > I then created two new chunks, tmpchunk1 and tmpchunk2, in the dbspaces. > > Then I dropped the database. > > When I'm trying to import it, it starts to import, but after a while it stops. > > The first chunk, chunk1, in the datadbs is full, nothing is written in the other > chunks, chunk2 and so on. > > In the dbimport - file I get the message "No space left on device". > > And, yes, there is no space left in chunk1, but why don' the import continues to > chunk2? > > Is it not possible to make a dbexport, then change the name of a dbspace, and > then make a dbimport? > > Thanks in advance.

did you update your onconfig with the new TEMP spaces ? If not it will write to /tmp (if you're on unix) so you may hit a filesystem full. dbimport uses your tempdbspaces for index creation. Peter >----- Original Message ----- >From: Anders Beng.... <anders.bengtsson@hkv.mil.se> >At: 6/26 7:28 > > > >>I am on informix 7.3 >> >>I have dumped my database with dbexport >>Then I changed the name of tempdspace to tempdbspace1 and created a new one >>called tempdbspace2. >>I then created two new chunks, tmpchunk1 and tmpchunk2, in the dbspaces. >> >>Then I dropped the database. >> >>When I'm trying to import it, it starts to import, but after a while it stops. >> >>The first chunk, chunk1, in the datadbs is full, nothing is written in the >> >> >other > > >>chunks, chunk2 and so on. >> >>In the dbimport - file I get the message "No space left on device". >> >>And, yes, there is no space left in chunk1, but why don' the import continues >> >> >to > > >>chunk2? >> >>Is it not possible to make a dbexport, then change the name of a dbspace, and >>then make a dbimport? >> >>Thanks in advance. >> >> > > > > > >