'Recovery' / 'Restore' for LUW.

Rupa Dutta

'Recovery' / 'Restore' for LUW.
Hello Listeners,

Can someone throw some light on the difference between 'Recovery'
and 'Restore' in DB2 for LUW.

Are there any thumb rules to decide between 'Recover' and 'Restore'?
When should one use 'Recover' and when should one use 'Restore'?

Rupa.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Philip Gunning

Re: 'Recovery' / 'Restore' for LUW.
(in response to Rupa Dutta)
In a Nutshell, restore in not automatic, you need to specify backup image and whether or not rollforward is done, with recover, I believe this was new in 9.5, recover will automatically restore to the latest backup image available, etc. Check the Admin Guide for the details. PG

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Rupa Dutta
Sent: Monday, December 15, 2008 10:34 AM
To: [login to unmask email]
Subject: [DB2-L] 'Recovery' / 'Restore' for LUW.

Hello Listeners,

Can someone throw some light on the difference between 'Recovery'
and 'Restore' in DB2 for LUW.

Are there any thumb rules to decide between 'Recover' and 'Restore'?
When should one use 'Recover' and when should one use 'Restore'?

Rupa.

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

Anupama Chiluka

Re: 'Recovery' / 'Restore' for LUW.
(in response to Philip Gunning)
RECOVER DATABASE Command --Restores and rolls forward a database to a particular point in time or to the end of the logs.



Whereas



Restore database command - Have to issue ROLL FORWARD database command after successful restore.







Thanks

Anupama Chiluka

RemoteDBAExperts

O: 412 208 1641

C: 412 496 7560

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of Rupa Dutta
Sent: Monday, December 15, 2008 10:34 AM
To: [login to unmask email]
Subject: [DB2-L] 'Recovery' / 'Restore' for LUW.



Hello Listeners,



Can someone throw some light on the difference between 'Recovery'

and 'Restore' in DB2 for LUW.



Are there any thumb rules to decide between 'Recover' and 'Restore'?

When should one use 'Recover' and when should one use 'Restore'?



Rupa.



______________________________________________________________________



* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *

______________________________________________________________________







The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms

SUBSCRIBE DB2-L Muthuraj

Re: 'Recovery' / 'Restore' for LUW.
(in response to Anupama Chiluka)
Rupa,

Restore and Recover of UDB are comparable with RECOVER PIT and RECOVER TO
CURRENT of DB2 Z/os. After Restore, you have to build the index. Where as
for recover, you dont have to. Restore with Rollforward option is same as of
Recovery.
Restore can be done for a (set) tablespace(s). Where as its not possible for
Recovery. Please read backup and recovery manual which is really good.

Regards,
Muthu

______________________________________________________________________

* IDUG 2009 Denver, CO, USA * May 11-15, 2009 * http://IDUG.ORG/lsNA *
______________________________________________________________________



The IDUG DB2-L Listserv is only part of your membership in IDUG. The DB2-L list archives, FAQ, and delivery preferences are at http://www.idug.org/lsidug under the Listserv tab. While at the site, you can also access the IDUG Online Learning Center, Tech Library and Code Place, see the latest IDUG conference information and much more. If you have not yet signed up for Basic Membership in IDUG, available at no cost, click on Member Services at http://www.idug.org/lsms