If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 DPF restore/recovery

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Posts: 2
DB2 DPF restore/recovery

I have installed DB2 9.7 with DPF 3 partitions.
I took the backup of all the three nodes.
I want to understand the restore scenarios for the DPF environment, following are my doubts:
1. For restore is the necessary to restore the catalog node first?
2. Is it possible to resotre a single partition (non catalog node) separately
3. For roll forward do we need to run it from the catalog node?

Regards
Sanjeev
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,219
__________________
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Aug 2011
Posts: 2
DB2 DPF Backup/Recovery

Thanx Guy Przytula

Do you have pointers or any document for the steps to restore/recovery the database in DPF environment with respect to DB2 APIs.
We are writing a module to backup/restore DB2 databases in DPF environement. I am not able to find clear steps for the backup/recovery of DB2 databases in DPF environment.

Regards
Sanjeev
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,219
check the high availability guide on this page
https://www-304.ibm.com/support/docv...g=en&loc=en_US
__________________
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
Reply

Tags
db2 dpf

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On