Re: ontape sizing

Posted in 1997

Markus G. Holzbauer — Thu, 29 May 1997 13:41:02 +0200 — source: Informix-list mailing list archive (1991-1998)

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) -- With best regards Markus Holzbauer markus.holzbauer@mch.sni.de Online or not Online, that's the question here !?