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>>
>
|