title: db2 cant stop getting transaction log is fill error
body: <p>I am having a serious issue.. I have store procedure which updates, couple of million records. It all happens in a cursor.
  I am having issues that whatever I have done so far, it fails with transaction log full error
  SQL0964C The transaction log for the database is full. SQLSTATE=57011</p>
  
  <p>Over the past couple of days I have, one by one, made following changes to db configuration in hopes that log file will STOP getting filled
  I have set the following</p>
  
  <pre><code>LOGRETAIN = NO
  LOGARCHMETH1 = OFF
  LOGILESIZE=20000
  LOGPRIMARY=50
  LOGSECONDARY=200
  </code></pre>
  
  <p>Up to this morning ( Just changed LOGARCHMETH1 = OFF and sp is running) I have no luck. For now I just don't want to see this darn error, I wish this to stop so that I can move forward with my testing. I can deal with these performance issues later.
  Can some kind soul shed some light how in the heck I force db2 to NOT use logs other than what I have already tried?
  DB2 version is 8.2.4</p>