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 > rollforward command in DPF

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-24-11, 02:31
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
rollforward command in DPF

Can we use rollforward command in DPF using overflow log path option ? If so how do we do that ?

Generally to do a rollforward in DPF environmnet, I copy the logfiles of each partition to its own active log path directory and run a rollforward from admin node.

Is there an option where we can run rollforward command from the admin node by placing all the logfiles of all the partitions in one path and provide that path name in the overflow log path directory.
So basically my question would be: If we wanted to use over flow log path in rollforward command for a DPF environment, how do we do it.
Reply With Quote
  #2 (permalink)  
Old 02-24-11, 05:06
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
Here is an example of how you would use "overflow log path" in DPF:

rollforward db test to end of logs on all
dbpartitionnums overflow log path (
/test_dbbackup/test_Restore_Logs/NODE0000,
/test_dbbackup/test_Restore_Logs/NODE0001 on dbpartitionnum 1,
/test_dbbackup/test_Restore_Logs/NODE0002 on dbpartitionnum 2,
/test_dbbackup/test_Restore_Logs/NODE0003 on dbpartitionnum 3,
/test_dbbackup/test_Restore_Logs/NODE0004 on dbpartitionnum 4,
/test_dbbackup/test_Restore_Logs/NODE0005 on dbpartitionnum 5,
/test_dbbackup/test_Restore_Logs/NODE0006 on dbpartitionnum 6,
/test_dbbackup/test_Restore_Logs/NODE0007 on dbpartitionnum 7,
/test_dbbackup/test_Restore_Logs/NODE0008 on dbpartitionnum 8,
/test_dbbackup/test_Restore_Logs/NODE0009 on dbpartitionnum 9,
/test_dbbackup/test_Restore_Logs/NODE0010 on dbpartitionnum 10)
Reply With Quote
Reply

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