Simple backup doubt....

[Raquel]

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.

[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! =-----

[Larry]

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.

[Raquel]

Thank you Ian.

Raquel.