Re: ontape sizing
In article <338C3F7E.FFEA50E4@mch.sni.de>, "Markus G. Holzbauer"
<markus.holzbauer@mch.sni.de> writes
>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 ! }
>
I tried this an get a figure of 42Mb by excluding chunks in temporary
dbspaces which should not be backuped. Running an archive to disk
produced a 56Mb file!
I would archive to a disk file (change TAPEDEV to point to an
empty file), run the archive and see how big the file ends up...
--
David Williams