Re: tbload
Sorry if I wasn't clear.
I want to transfer data from server A to B. I used tbload, it failed but
dbexport succeeded. Knowing that I tbloaded the data from A to a third
server C also succeeded.
For all the cases, my dbspaces are large enough to hold the data of A.
My question is why I couldnt do tbload to server B while I did it for server
C??
TIA
Nien
-----Original Message-----
From: David Kosenko <davek@summitdata.com>
To: informix-list@iiug.org <informix-list@iiug.org>
Date: Thursday, June 25, 1998 04:49 '
Subject: Re: tbload
>"Ants" <insight@shabakah.com> offerred:
>+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????
>
>tbunload takes a raw dump of your tblspace, including pages allocated to
the tblspace
>but not currently containing any data. dbimport will create the table with
default
>extent sizes (unless dbexport -ss was used - not sure if that option was
even present
>in 5.0), so you should only need as much disk space as required by the data
being
>inserted + indexes.
>
>Dave
>
>
>** Dave Kosenko <davek@summitdata.com>
>** Director of Training Services (732) 469-4070
>** Summit Data Group (an Informix Authorized Education Center)
>** Find my advice useful? Let me teach you everything I know about
>** Informix. Sign up for OFFICIAL Informix training at SDG.
>** For details, see http://www.summitdata.com/training