title: Restore NON-SVV backup in db2 dpf
body: <p>I  took non-svv online backup of a DPF database (6 nodes):</p>
  
  <ul>
  <li><p>catalog Node 0 partition backup starts at 6Am and completed at 7AM</p></li>
  <li><p>Node 1 partition backup starts at 7AM and completed at 8AM, </p></li>
  <li><p>Node 2 partition backup starts at 8AM and completed at 9AM,</p></li>
  <li><p>Node 3 partition backup starts at 9AM and completed at 10AM,</p></li>
  <li><p>Node 4 partition backup starts at 10AM and completed at 11AM,</p></li>
  <li><p>Node 5 partition backup starts at 11AM and completed at 12PM</p></li>
  </ul>
  
  <p>Now I have to restore this backup to another sever. I am going to use  <code>rollforward to end of logs and complete</code> with the overflowpath (containing logs from the <code>logtarget</code> used in the restore command).</p>
  
  <p>So my questions are :</p>
  
  <ol>
  <li><p>New restored database will be consistent?</p></li>
  <li><p>If yes, till what time it will have the consistency (6AM, 7AM or 12PM )?</p></li>
  </ol>
  
  <p>Below are the commands used :</p>
  
  <pre><code>db2_all "db2 backup db db1 online compress"
  
  db2_all '&lt;&lt;+0&lt; db2 restore db db1 taken at &lt;timestamp&gt; into db11 logtarget /tmp/logtar
  
  db2_all '&lt;&lt;-0&lt; db2 restore db db1 taken at &lt;timestamp&gt; into db11 logtarget /tmp/logtar
  
  
  db2 rollforward db db11 to end of logs and stop overflow log path /tmp/logtar
  </code></pre>