Re: [Q] Dbexport and file space?
Additionally to Neil answer I'd like to answer the second question.
I have an idea that will work definitely in ksh:
dbexport dbname -t >(compress - > dbname.exp.Z) -b 1024 -s 2000000000
Of course you have to assure that the resulting file will not be more than 2Gb
(on most systems without large files support I think).
Best Regards,
Octav
On Fri, Aug 06, 1999 at 07:43:20PM +0000, L wrote:
> I am UNIX system admin and I don't know anything about Informix,
> but I have very strong ORACLE DBA experienced. Today, I argue
> with our INFORMIX DBA. He ask me allocate at least 4GB free space for him
> to do the "dbexport. His reason base on Informix database already
> take 4GB chunk. Base on my ORACLE experience, export database take
> less space than actual database take. I mention to Informix DBA,
> when FIRST time new project doing export, we always need "try and
> error" several times to figure out how many space we need. He
> refuse to do that and ask me allocate large space for him. My
> question are:
>
> 1. how can we estimate how big space need for dbexport?
>
> 2. is it possible we can compress files while dbexport
> (for example on ORACLE we can "exp file= aaa ...|compress)?
>
> Thanks you for help.
--
Octav Chiriac Phone: (373) 2 22 99 67
NetInfo S.R.L. Fax: (373) 2 21 36 59
Chisinau (373) 2 22 84 88
Moldova, Republic of mailto:com@netinfo-moldova.com
> dbexport dbname -t >(compress - > dbname.exp.Z) -b 1024 -s 2000000000
>
I see where you are going here, but isn't this a two step process
where you will need the 'large' amount of space for a (short) time
before the compressions takes place?