Re: Legato tape capacity for Informix data
Sean Curran wrote:
>
> We are backing up an Oracle database to a Sun ETL with dual dlt7000
> drives using raw directives
> for Veritas volumes and seeing 100-200GB per tape as a result.
>
> I am trying to do the same with Informix 7.2.2 on a comparable machine
> with an ETL with dual
> dlt7000 drives using raw directives for Veritas volumes and seeing
> 40-45GB per tape as a result.
>
> Sun has said that is a function of how compressible Informix data is
> compared to Oracle data
> as it sits on the disks. That Oracle data is more "holey" (not to be
> confused with Holy)
> than Informix data as it sits on disks.
>
> Anyone ever heard this before?
>
> Anyone getting better per tape loading of Informix data via Solstice
> Backup 5.1 (Legato Networker)?
>
> TIA,
> Sean Curran
>
> --
>
> *-------------------------------------------------------------*
> | Sean Curran + Epsilon |
> | UNIX Sys Admin + 50 Cambridge St. |
> | scurran@epsilon.com + Burlington, MA 01803 |
> | 800-225-1970 x6858 + (F)781-229-6012 |
> *-------------------------------------------------------------*
> Always look at the bright side of life.
> -Monty Python
Sean,
How are you configuring the tape drives vs dbspaces map?
Informix (onbar) backs up only the part of the dbspaces that
contain data as opposed to Oracle's copy of the entire tablespace.
So, if you have one tape per dbspace map in onbar, then
this is OK as long as that dbspace has no more than the sizes
you're seeing.
Arun