title: Restoring database not all rows restored
body: <p>I have a table <code>EMPLOYEE.EMPLOYEE</code> inside database <code>HELLO</code> which contains 3 records as listed below:</p>
  
  <pre><code>EMP_NO  BIRTH_DATE FIRST_NAME         LAST_NAME            GENDER HIRE_DATE  BANK_ACCOUNT_NUMBER PHONE_NUMBER  
  ------- ---------- ------------------ -------------------- ------ ---------- ------------------- --------------
       1. 06/05/1998 A                  B                     M     01/02/2019 026201521420        +91X 
       2. 10/14/1997 C                  D                     M     01/07/2019 034212323454        +91Y 
       3. 05/27/1997 E                  F                     F     01/14/2019 92329323123         +91Z 
  </code></pre>
  
  <p>Then I first take an offline backup using the following commands</p>
  
  <pre><code>mkdir offlinebackup
  db2 terminate
  db2 deactivate database HELLO
  db2 backup database HELLO to ~/offlinebackup/
  </code></pre>
  
  <p>After which I get this output:</p>
  
  <pre><code>Backup successful. The timestamp for this backup image is : 20190128115210
  </code></pre>
  
  <p>Now I take an online backup using the following commands</p>
  
  <pre><code>db2 update database configuration for HELLO using LOGARCHMETH1 'DISK:/database/config/db2inst1/onlinebackup'
  db2 backup database HELLO online to /database/config/db2inst1/onlinebackup compress include logs
  </code></pre>
  
  <p>After this I get the output as:</p>
  
  <pre><code>Backup successful. The timestamp for this backup image is : 20190128115616
  </code></pre>
  
  <p>Now I go back to db2 and run <code>CONNECT TO HELLO</code> which connects me to my database. When I check for rows in the <code>EMPLOYEE.EMPLOYEE</code> table, I still get all my 3 rows.</p>
  
  <p>Now I remove the row with EMP_NO 3. This gets succesfully removed. Then I run <code>quit</code> from the db2 terminal</p>
  
  <p>Then I use this command to run the restore from my offline backup:</p>
  
  <pre><code>db2 restore db HELLO from ~/offlinebackup/ replace existing
  </code></pre>
  
  <p>It says <code>DB20000I  The RESTORE DATABASE command completed successfully</code></p>
  
  <p>Now I try to connect to HELLO, it says <code>SQL1117N  A connection to or activation of database "HELLO" cannot be made because of ROLL-FORWARD PENDING.  SQLSTATE=57019</code></p>
  
  <p>To which I run <code>db2 rollforward db HELLO to end of logs and stop</code></p>
  
  <p>Then I connect to HELLO and try to find out the rows, I get only 2 rows, and not 3 as it was in the backup.</p>
  
  <pre><code>EMP_NO  BIRTH_DATE FIRST_NAME         LAST_NAME             GENDER HIRE_DATE  BANK_ACCOUNT_NUMBER PHONE_NUMBER  
  ------- ---------- ------------------ --------------------- ------ ---------- ------------------- --------------
       1. 06/05/1998 A                  B                     M      01/02/2019 026201521420        +91X 
       2. 10/14/1997 C                  D                     M      01/07/2019 034212323454        +91Y
  </code></pre>
  
  <p>The third record is not visible, which was present in the backup. Can anyone figure out why I am not able to restore the third record from the backup</p>