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)
?