Re: ontape sizing
Silvester_Valiente@tnt.com.au wrote:
>
> Has anyone discovered a reliable way of estimating the size of an
> ontape archive?
>
> ie how many bytes are required to perform a level 0 archive?
>
> - TIA
>
> Silvester Valiente
> Informix/Ingres DBA
> TNT Australi
With Online 6.x, 7.x you can also try this:
SELECT (SUM(chksize - nfree))*2 { if pagesize == 2 }
FROM sysmaster:syschktab { sum in kbytes ! }
--
With best regards
Markus Holzbauer markus.holzbauer@mch.sni.de
Online or not Online, that's the question here !?