backup question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jag - 13 Apr 2006 21:53 GMT

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

Reply to this Message

Ian - 14 Apr 2006 08:02 GMT

> hi,
>
[quoted text clipped - 5 lines]
> 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)

?

Reply to this Message

Bob [IBM] - 14 Apr 2006 14:17 GMT

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

Reply to this Message

Ian - 14 Apr 2006 18:24 GMT

>>> 2. Can i take backup of only tablespaces ( all of them in current
>>> database ) and then can restore database from those tablespace backups
[quoted text clipped - 3 lines]
>>
> 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/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.
udb.admin.doc/doc/c0022321.htm

Reply to this Message

Bob [IBM] - 14 Apr 2006 18:37 GMT

>>>> 2. Can i take backup of only tablespaces ( all of them in current
>>>> database ) and then can restore database from those tablespace backups
[quoted text clipped - 9 lines]
>
> http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.
udb.admin.doc/doc/c0022321.htm

Yes in Viper -- I took from your post that it was in a fixpack post V8.2
prior to V9.

Reply to this Message

jag - 22 Apr 2006 15:37 GMT

thanks to all for help

Reply to this Message