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