title: Is a commit needed on a select query in DB2?
body: <p>I have a vendor reporting product executing queries to pull report data, no inserts, no updates just reading data. </p>
  
  <p>We have double our heap size 3 times and are now at 1024 4k pages, The app will run fine for a week then we will begin to see DB2 SQL error: SQLCODE: -954, SQLSTATE: 57011 indicating the transaction log is not able to accomodate the request. </p>
  
  <p>Its not the size of the reports since they run fine after a recycle. I spoke with another DBA on this. He believe the problem was in a difference between ORACLE and DB2 in that the vendor code is crappy and not issuing commits on the selects. This is causing the references to not be cleaned up and is slowly accumulating as garbage in the heap. </p>
  
  <p>I wanted to know if this is accurate as I thought only inserts and updates needed to have commits included. Is there any IBM documentation on this?</p>
  
  <p>We are currently recycling on a weekly basis to alleviate the problem but I would like to have a good handle on the issue before going back to the vendor asking them to alter their code. </p>