Re[2]: tbload

Jeff, You can't use tbunload/onunload across versions. The data structures are usually different. Dbexport can use less space if the database is not full eg: you have allocated 10 gb of dbspaces and only have 1 row in the database. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Re: tbload Author: <jeffso@lucent.com> at WCA-INET Date: 24/6/98 2:56 PM Nils.Myklebust@nmdata.com wrote: I think this is incorrect. Bbexport requires much more disk/tape space than tbunload. I suspect that you made mistake in specifing the tape size. BTW, check the informix version again. I had an experience that the unload failed when I try to move the data between 7.23UC1 and 7.23UC5. > > On Wed, 24 Jun 1998 15:39:09 +0300, "Ants" <insight@shabakah.com> > wrote: > > > > >Hi, > > > >I have tried to tbunload a database from one server and tbload it to another > >server. The process failed due to insufficient space. But when I do dbexport > >and import it works. > > > >The only different between the two servers are phy log size, one is 2000K > >and the other is 3000K, is that the problem or what???? > > > >Informix online 5.05 > >AIX 3.2.5 > > When you do tbunload binary data is written to diskfiles as it's > stored in the database. When you use dbexport ascii data is written > with variable field length and a delimiter between the fields. This > format apperantly requires less space than the original binary data in > the database (not uncommon). The physical log isn't involved in any of > this at all. > -- Jeff So Office : 973-3868839 Email : jeffso@lucent.com