title: Difference between the use of FOR FETCH ONLY in query & ResultSet.CONCUR_READ_ONLY in JDBC statement
body: <p>My application is running 200 select statements per second (like SELECT A, B, C FROM DUMMYSC.DUMMYTB, etc.). 10-15% of the queries fail with the error below:</p>
  <p><code>DB2 SQL Error: SQLCODE=-913, SQLSTATE=57033, SQLERRMC=00C9008E;00000304;DSNDB06 .SYSTSTSS.X'000001C5'.X'0C' </code></p>
  <p>I'm looking to use one of the solutions below, but unable to understand the difference between the two.</p>
  <p><strong>ResultSet.CONCUR_READ_ONLY</strong> in
  <code>statement = connection.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);</code></p>
  <p>&amp;
  <strong>FOR FETCH ONLY</strong> in <code>SELECT A, B, C FROM DUMMYSC.DUMMYTB FOR FETCH ONLY</code>.</p>