ADSM-L

SLOW offline backups

2005-02-17 16:21:39
Subject: SLOW offline backups
From: Muthyam Reddy <MREDDY AT JOY DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 17 Feb 2005 16:20:46 -0500
** High Priority **



Kind men,

As I could not find in IBM docs, I am querying these questions to the
experts,

In my environment we have a production database size of 550Gb which
takes 3hrs for online backup to tape storage pools which is fine for
me.
When I tried for offline backup on same database it is taking  7hrs
which is technically wrong  since offline backups should take less
time.
I am not using any backup parameters for offline backup and my backup
command looks like " backup db xyz use tsm" .

My questions...
Do you guys use any kind of offline backup parameters like buffer
size..etc ?
On what factored offline backup depends?
Is there any thing we have to change in DB2/TSM parameters?
Is it going to improve if I use diskpool first and then tapepools.If
yes, how much diskpool size it requires for 550GB and is there any
rules
we can look for before create disk pools.

I really appreciate for your inputs.

thanks and regards
Muthyam




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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>
  • SLOW offline backups, Muthyam Reddy <=