RE: Space on tape

You could try ... use dd to copy from your tape to /dev/null with input block size the same as your archive (tapeblk in onconfig). dd will tell you the number of blocks, hence the volume of data on the tape. MW (Disclaimer - Never done this) -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Art S. Kagel Sent: Friday, February 09, 2001 1:12 PM To: informix-list@iiug.org Subject: Re: Space on tape Vasilis Econmonides wrote: > > I have the following questions regarding the on-tape utility: > > 1. I am using Informix 7.22 on SCO Unix 5.0.5. How can I check how much > space > the ontape backup occupies on the tape? > > 2. Currently I have a database with 6 dbspaces. The total capacity of > those is about 36 GB. The > ontape backup fits on one tape (DLTtape IV). If I increase the number > of dbspaces and > also the capacity to 150 GB will the ontape backup fit on one tape? > What I mean is that > does the ontape utility backup the total space allocated to dbspaces > either free of occupied by data) > or only the data? Only used pages are archived. Art S. Kagel

That's a clever one. I'll have to try it... However, that wouldn't tell you how much tape length would be left. <showing ignorance from now on...> If I have a tape drive that supports compression, I guess my <TAPEBLK> byte blocks will occupy a different length on the actual tape depending upon the data content. I wonder if trying to read the tape as you suggest, but with the non- compressing device, we'd get the 'right' answer... Ho, hum. In article <95vlje$skk$1@news.xmission.com>, Murray Wood <murray@quanta.co.nz> writes > >You could try ... use dd to copy from your tape to /dev/null with input >block size the same as your archive (tapeblk in onconfig). dd will tell you >the number of blocks, hence the volume of data on the tape. > >MW > (Disclaimer - Never done this) > >-----Original Message----- >From: owner-informix-list@iiug.iiug.org >[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Art S. Kagel >Sent: Friday, February 09, 2001 1:12 PM >To: informix-list@iiug.org >Subject: Re: Space on tape > > >Vasilis Econmonides wrote: >> >> I have the following questions regarding the on-tape utility: >> >> 1. I am using Informix 7.22 on SCO Unix 5.0.5. How can I check how much >> space >> the ontape backup occupies on the tape? >> >> 2. Currently I have a database with 6 dbspaces. The total capacity of >> those is about 36 GB. The >> ontape backup fits on one tape (DLTtape IV). If I increase the number >> of dbspaces and >> also the capacity to 150 GB will the ontape backup fit on one tape? >> What I mean is that >> does the ontape utility backup the total space allocated to dbspaces >> either free of occupied by data) >> or only the data? > >Only used pages are archived. > >Art S. Kagel > Andrew Lennard andy@kontron.demon.co.uk

You know how big your tape is .... convert it to blocks and subtract what's used from it. Yours -- Earle A Long (Senior DBA) SinglePoint Limited "Andy Lennard" <andy@kontron.demon.co.uk> wrote in message news:f0S0ANAR05g6EwA2@kontron.demon.co.uk... > That's a clever one. I'll have to try it... > > However, that wouldn't tell you how much tape length would be left. > > <showing ignorance from now on...> > > If I have a tape drive that supports compression, I guess my <TAPEBLK> > byte blocks will occupy a different length on the actual tape depending > upon the data content. > > I wonder if trying to read the tape as you suggest, but with the non- > compressing device, we'd get the 'right' answer... > > Ho, hum. > > In article <95vlje$skk$1@news.xmission.com>, Murray Wood > <murray@quanta.co.nz> writes > > > >You could try ... use dd to copy from your tape to /dev/null with input > >block size the same as your archive (tapeblk in onconfig). dd will tell you > >the number of blocks, hence the volume of data on the tape. > > > >MW > > (Disclaimer - Never done this) > > > >-----Original Message----- > >From: owner-informix-list@iiug.iiug.org > >[mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Art S. Kagel > >Sent: Friday, February 09, 2001 1:12 PM > >To: informix-list@iiug.org > >Subject: Re: Space on tape > > > > > >Vasilis Econmonides wrote: > >> > >> I have the following questions regarding the on-tape utility: > >> > >> 1. I am using Informix 7.22 on SCO Unix 5.0.5. How can I check how much > >> space > >> the ontape backup occupies on the tape? > >> > >> 2. Currently I have a database with 6 dbspaces. The total capacity of > >> those is about 36 GB. The > >> ontape backup fits on one tape (DLTtape IV). If I increase the number > >> of dbspaces and > >> also the capacity to 150 GB will the ontape backup fit on one tape? > >> What I mean is that > >> does the ontape utility backup the total space allocated to dbspaces > >> either free of occupied by data) > >> or only the data? > > > >Only used pages are archived. > > > >Art S. Kagel > > > > Andrew Lennard andy@kontron.demon.co.uk >