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:[EMAIL PROTECTED] Im > Auftrag von Muthyam Reddy > Gesendet: Mittwoch, 02. Februar 2005 19:28 > An: ADSM-L@VM.MARIST.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>> >
