Re: ontape sizing
This is great when the size of data is in MBs, what about if it is in Gigs?
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
On Wed, 28 May 1997, David Williams wrote:
} 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
}