Re: Size on Ontape Backup

In article <6h5n5l$2g2$1@news.xmission.com>, ssoman@omm.com writes > > >Hi all, > I know that variations of this question have been asked before, but my >question is a little different ( I hope ). I just need to know how the size of >an ontape level 0 backup varies with actual dbspace size. What I mean is, if I >add a new dbspace with 5 chunks, and don't add data to it, will my ontape >bakckup size increase by 10GB ( if 2GB is the size of a chunk ). I'm pretty sure >it doesn't, but I am planning to re-org my database to a large extent, will be >adding new disks, new dbspaces, new chunks etc and I want to accurately >determine the number of tapes needed. Of course, I am not going to leave my >dbspaces empty, I plan to move large tables to their own dbspaces, but I intend >to take one backup with the new dbspaces/chunks before I start the real move. > >Thanks as usual > >Sujata > > I believe only used pages are backed up. This is why ontape jumps from 10% done to 90% done in one go! > >***************************************** > Sujata Soman > > > E-Mail: ssoman@omm.com > > O'Melveny & Myers, Los Angeles > >****************************************** > > > > > > > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care