Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
David Williams — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.