title: Insert one large amount of data in one transaction
body: <p>I have struggled with architectural problem. </p>
  
  <p>I have table in DB2 v.9.7 database in which I need to insert ~250000 rows, with 13 columns each, in a single transaction. I especially need that this data would inserted as one unit of work. </p>
  
  <p>Simple <code>insert into</code> and <code>executeBatch</code> give me:</p>
  
  <blockquote>
    <p>The transaction log for the database is full. SQL Code: -964, SQL State:     57011 </p>
  </blockquote>
  
  <p>I don't have rights to change the size of transaction log. So I need to resolve this problem on the developer's side.</p>
  
  <p>My second thought was to use savepoint before all inserts then I found out that works only with current transaction so it doesn't help me.</p>
  
  <p>Any ideas? </p>