ADSM-L

AW: DB2 offline backups

2005-02-02 13:35:01
Subject: AW: DB2 offline backups
From: Salak Juraj <J.Salak AT ASAMER DOT AT>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 2 Feb 2005 19:34:04 +0100
while not beeing DB2 expert in any way I have my 2 cents:

assuming both scenarii perform full backup,
I suspect online backup backups only used database space (which size you did 
not mention)
while offline backup, obviously, backups up the whole - reserved space,
and you maybe do not use compression on the tsm client, and maybe not even on 
tapes.
Just a guess, go give it a check

Juraj


> -----Ursprüngliche Nachricht-----
> Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im 
> Auftrag von Muthyam Reddy
> Gesendet: Mittwoch, 02. Februar 2005 19:28
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: DB2 offline backups
> Wichtigkeit: Hoch
> 
> ** High Priority **
> 
> Hi,
> We have DB2 database of size 530GB and it takes 3hrs time for 
> online backup with 4 tsm drives. When tried with same TSM/DB2 
> parameters and drives for offline backup it taking 7hrs. I 
> know it should take far less time for offline backups compare 
> to online.  I appreciate if any one can share their ideas to 
> improve offline backup window time.
> Meanwhile I will search docs for anything I have to change.
> 
> thanks and regards
> muthym
> 
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++++++++++++
> This electronic mail transmission contains information from 
> Joy Mining Machinery which is confidential, and is intended 
> only for the use of the proper addressee.
> If you are not the intended recipient, please notify us 
> immediately at the return address on this transmission, or by 
> telephone at (724) 779-4500, and delete this message and any 
> attachments from your system.  Unauthorized use, copying, 
> disclosing, distributing, or taking any action in reliance on 
> the contents of this transmission is strictly prohibited and 
> may be unlawful.
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++++++++++++
> <<privacy>>
> 

<Prev in Thread] Current Thread [Next in Thread>
  • AW: DB2 offline backups, Salak Juraj <=