Re: ontape sizing

Posted in 1997

David Williams — Thu, 29 May 1997 21:08:35 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <338D6B4E.118C3380@mch.sni.de>, "Markus G. Holzbauer" <markus.holzbauer@mch.sni.de> writes >David Williams wrote: >> >....snip >> 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 >Dave, >sorry but I forgot the temporary dbspaces. here is the better one: > > SELECT (SUM(chksize - nfree))*2 > FROM sysmaster:syschktab > WHERE dbsnum NOT IN > (SELECT dbsnum FROM sysdbspaces WHERE is_temp = 1) > Try archiving to disk and see if that correctly gives the size of the output file... -- David Williams