Table Locks in OnLine 7.x

Posted in 1998

Mark Goldin — Thu, 19 Nov 1998 23:31:58 -0800 — source: Informix-list mailing list archive (1991-1998)

Does anyone know under which query circumstances OnLine will lock a table? The manual makes a brief mention of this but provides no examples. I suspect that aggregate queries may place some kind of table lock. If this is true, does it depend on isolation levels? Is there some other way to avoid locking the entire table? This would be similar to lock escalation in SQL Server which CAN be circumvented. Mark