Re: tbload

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. Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)