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

backup question

P: n/a
jag
hi,

I am thinking about backup strategy. I have couple of questions for my
db2 community brothers.

1. Can i use full online or offline database backup as base for
incremental backup for tablespace? For example, if i take backup of
database A which contain tablespace X1,X2, can i take full offline or
online backup of A and then take incremental backup of X1,X2?

2. Can i take backup of only tablespaces ( all of them in current
database ) and then can restore database from those tablespace backups
without having any database level backup ?

3. is backup for all tablespaces in database slower than database
backup ?
regards,
jag

Apr 13 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Ian
jag wrote:
hi,

I am thinking about backup strategy. I have couple of questions for my
db2 community brothers.

1. Can i use full online or offline database backup as base for
incremental backup for tablespace? For example, if i take backup of
database A which contain tablespace X1,X2, can i take full offline or
online backup of A and then take incremental backup of X1,X2?
Yes, provided TRACKMOD configuration parameter is ON.
2. Can i take backup of only tablespaces ( all of them in current
database ) and then can restore database from those tablespace backups
without having any database level backup ?
Not in V8.2 or earlier.
3. is backup for all tablespaces in database slower than database
backup ?

Do you mean comparing:

backup database sample
vs
backup database sample
tablespace (syscatspace, tempspace1, userspace1)

or
backup database sample tablespace (syscatspace)
backup database sample tablespace (tempspace1)
backup database sample tablespace (userspace1)
?
Apr 14 '06 #2

P: n/a
Ian wrote:
2. Can i take backup of only tablespaces ( all of them in current
database ) and then can restore database from those tablespace backups
without having any database level backup ?


Not in V8.2 or earlier.

Has this been added post V8.2?

Bob
Apr 14 '06 #3

P: n/a
Ian
Bob [IBM] wrote:
Ian wrote:
2. Can i take backup of only tablespaces ( all of them in current
database ) and then can restore database from those tablespace backups
without having any database level backup ?


Not in V8.2 or earlier.

Has this been added post V8.2?


I'd tell you, but then I'd have to kill you! :-)
Well, I guess this is public information, so:

http://publib.boulder.ibm.com/infoce...c/c0022321.htm

Apr 14 '06 #4

P: n/a
Ian wrote:
Bob [IBM] wrote:
Ian wrote:
2. Can i take backup of only tablespaces ( all of them in current
database ) and then can restore database from those tablespace backups
without having any database level backup ?

Not in V8.2 or earlier.

Has this been added post V8.2?


I'd tell you, but then I'd have to kill you! :-)
Well, I guess this is public information, so:

http://publib.boulder.ibm.com/infoce...c/c0022321.htm

Yes in Viper -- I took from your post that it was in a fixpack post V8.2
prior to V9.
Apr 14 '06 #5

P: n/a
jag
thanks to all for help

Apr 22 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.