title: Informix error on read: could not do a physical order read
body: <p><strong>Problem in nutshell</strong> </p>
  
  <ul>
  <li>executed data updates on couple of tables using dbeaver</li>
  <li>later reads from these tables started failing</li>
  <li>looks like the rows/pages in these tables are locked by the session where updates are done</li>
  <li>cant seem to get the locks released</li>
  </ul>
  
  <p><strong>The details</strong></p>
  
  <ul>
  <li>connected to an informix db using dbeaver</li>
  <li>updated a column in one row of a table</li>
  <li>added a few rows to another table</li>
  <li>ran selects to verify the updates</li>
  <li>ran a .net app that depends on these tables, and when it attempted to read the data from this table, it started throwing an error</li>
  <li><p>opened another session in dbeaver, ran a select to find the rows i updated, now i get same error</p>
  
  <ul>
  <li>for the table with updates...  SQL Error [IX000]: Could not do a physical-order read to fetch next row. Could not do a physical-order read to fetch next row. java.sql.SQLException: ISAM error: record is locked.</li>
  <li>for the table with inserts...  SQL Error [IX000]: Could not position within a
  file via an index. Could not position within a file via an index. java.sql.SQLException: ISAM error: key value locked</li>
  </ul></li>
  <li><p>dug in a bit about the errors, understood that it could be due to tables/pages/rows getting locked</p></li>
  <li>pulled up the current locks on the table using the table sysmaster:syslocks</li>
  <li>confirmed that there are exclusive page locks (may be exclusive row locks, not sure) on the tables that are updated</li>
  <li>confirmed that there are exclusive intent table locks on the tables that are updated</li>
  <li><p>confirmed that the above two are indeed initiated by my dbeaver session using the sysmaster:syssessions table</p></li>
  <li><p>tried restarting dbeaver, tried restarting pc, but none seem to release the exclusive locks</p></li>
  <li>my small bit of reading suggests that these should be released automatically, but it doesnt seem like it</li>
  </ul>
  
  <p><strong>How can I get these locks released? any help or direction is appreciated :)</strong></p>