ADSM-L

Re: DATABASE backup question FULL or INCREMENTAL?

2001-04-09 10:35:56
Subject: Re: DATABASE backup question FULL or INCREMENTAL?
From: "Chibois, Herve" <Chibois_H AT ADMIRAL DOT FR>
Date: Mon, 9 Apr 2001 16:37:27 +0200
Hi Dave,

it seems that your are doing a FULL db backup on an external site.

How big is your DB. Usually, when people are short of resource
(you should not be in that case under os/390) they often do a full
on tape (or external site) once a week, and incremental on disk
during week. IMHO, there is not a "good way" and a "bad way" to
save your DB. It depends on many params such as how many % are
changed each night, how big is your DB, how powerfull is you
server, how many disk you have, and finally which kind of tapes
you are using.
TSM Administrators do not like to waste a 40 GB tape for a 500 MB
DB backup; that why sometimes, DB is save on disk.

rv

> -----Message d'origine-----
> De : David Browne. [mailto:dbrowne AT HUMANA DOT COM]
> Envoyé : lundi 9 avril 2001 16:23
> À : ADSM-L AT VM.MARIST DOT EDU
> Objet : DATABASE backup question FULL or INCREMENTAL?
> 
> 
> I am doing a nightly database full backup with ADSM/TSM.  
> (TSM 3.7.4 on
> OS390/2.10)
> What is most commonly done a Full or Incremental?
> What are the advantages/disadvantages of a full over an 
> incremental backup
> of the servers database?
> The command we enter is as follows:
>                       backup db type=full devclass=dboffsite
>  Where dboffsite is the a tape device class.
>