Lock Escalation

Can someone please tell me if Informix v7.x does the following? 1. I have a central table with row-level locking, committed read isolation. 2. I have 30-50 people at a time doing updates to the table at random times 3. I have 3-4 people doing queries to the table at random times. 4. The people doing queries occasionally get errors stating that the data they are requesting is unavailable. 5. The question is this: can the database *automatically* escalate locks from row-level to page-level to table-level, depending on the circumstances (i.e. a query on a large number of rows, or concurrent multiple single row updates)? 6. Assuming we agree to the possibility of reading old data, will setting isolation to 'dirty read' correct the problem so that queries always work? Thanks in advance, Herb ------------------------------------------------------------------------- Herb Blacker (blackerh@jcdc.jobcorps.org) Cimarron, Inc. Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------