title: Data movement utility in db2
body: <p>Why the <code>not logged initially</code> option during the data movement is faster than using the <code>LOAD</code> utility in DB2?</p>
  
  <p>Not logged initially Method:</p>
  
  <pre><code>db2 alter table tablename activate not logged initially
  
  db2 insert into table tablename select * from tbname
  </code></pre>
  
  <p>Load Utility:</p>
  
  <pre><code>db2 declare source cursor for select * from tablename
  
  db2 load from source of cursor insert into tablename nonrecoverable
  </code></pre>