By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,839 Members | 2,270 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,839 IT Pros & Developers. It's quick & easy.

Simple backup doubt....

P: n/a
I am a newbie to UDB and reading the backup processes on UDB which
look pretty good to me. Now, if these good backup and recovery
procedures are already available 'within' UDB, what extra convenience
and feature do products such as TSM etc. provide?

For example, if I am using 'native' UDB (without TSM etc.) for all my
backup/recovery needs, I appreciate that I must be pretty thorough
with my understanding of recovery related concepts so that I don't
'mess things up'. Like pruning recovery history file, deleting
backups, overwriting logs after PIT recoveries etc. etc.

Does TSM in some way, simplify the process (or in other words, make up
for my incomplete understandig of how recovery works on UDB). Don't I
have to be a UDB expert (thorough will all the concepts of backup and
recovery) to perform backups and recoveries on TSM.

TIA
Raquel.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ian
Raquel wrote:
I am a newbie to UDB and reading the backup processes on UDB which
look pretty good to me. Now, if these good backup and recovery
procedures are already available 'within' UDB, what extra convenience
and feature do products such as TSM etc. provide?

For example, if I am using 'native' UDB (without TSM etc.) for all my
backup/recovery needs, I appreciate that I must be pretty thorough
with my understanding of recovery related concepts so that I don't
'mess things up'. Like pruning recovery history file, deleting
backups, overwriting logs after PIT recoveries etc. etc.

Does TSM in some way, simplify the process (or in other words, make up
for my incomplete understandig of how recovery works on UDB). Don't I
have to be a UDB expert (thorough will all the concepts of backup and
recovery) to perform backups and recoveries on TSM.


You still need to understand how DB2 recovery works.

TSM takes care of putting the data on tape, handling disaster recovery,
etc. This does make your life easier, because the storage management
is handled by the TSM administrator. :-)

Unfortunately DB2's support for TSM does not allow some of the more
"advanced" TSM features like retention periods to be used, so you
still need to manage the DB2 backups within TSM using the db2adutl
utility.

TSM does simplify things if you're using archive logging -- the user
exit code for TSM handles archiving and retrieving log files for you,
which makes life easier.


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2

P: n/a
Raquel,

Sooner or later ... you are going to run out of space in your filesystem
or backup directory. The idea behind TSM is to automatically manage your
backups and automatically archive them. DB2 UDB is integrated with TSM
so they know how to work together.

Larry Edelstein

Raquel wrote:
I am a newbie to UDB and reading the backup processes on UDB which
look pretty good to me. Now, if these good backup and recovery
procedures are already available 'within' UDB, what extra convenience
and feature do products such as TSM etc. provide?

For example, if I am using 'native' UDB (without TSM etc.) for all my
backup/recovery needs, I appreciate that I must be pretty thorough
with my understanding of recovery related concepts so that I don't
'mess things up'. Like pruning recovery history file, deleting
backups, overwriting logs after PIT recoveries etc. etc.

Does TSM in some way, simplify the process (or in other words, make up
for my incomplete understandig of how recovery works on UDB). Don't I
have to be a UDB expert (thorough will all the concepts of backup and
recovery) to perform backups and recoveries on TSM.

TIA
Raquel.


Nov 12 '05 #3

P: n/a
Thank you Ian.

Raquel.
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.