Re: How to find out why a table is locked? (2nd try)
<color><param>0100,0100,0100</param>En Sven C. Koehler va escriure el dia 24 Jul 2000, a les 20:51: <italic><color><param>7F00,0000,0000</param>> Madison Pruet <<mpruet@home.com> writes: > > >Mode Ansi enforces repeatable read. That means that if a transaction reads a row > >it places a shared lock on the row. That shared lock will prevent the row from > >being altered or deleted by another thread. I suspect that is what has happened. > > > > Did I get you right? If a process reads a row from the database > outside a transaction, it remains locked beyond the execution of the > read statement (eg. select from)? That sounds strange to me... > However, do you have any hints to get informix only locking rows when an > actual statement is executed, so the lock will be removed after the read > operation completed? > > Best regards, > > Sven Koehler > > -- > email: schween at snafu de > </italic></color>I i'm not wrong ANSI mode It's a hard transactional mode. See below. ---- <color><param>0100,0100,0100</param><FontFamily><param>Times New Roman</param><smaller>Repeatable Read Acquires a shared lock on every row that is selected during the transaction. Another process can also acquire a shared lock on a selected row, but no other process can modify any selected row during your transaction or insert a row that meets the search criteria of your query during your transaction. If you repeat the query during the transaction, you reread the same information. The shared locks are released only when the transaction commits or rolls back. Repeatable Read is the default isolation level in an <smaller>ANS<bigger>I-compliant database. --- <FontFamily><param>Arial</param>(Extract from<FontFamily><param>Times New Roman</param> Informix Guide To SQL IDS Ver 7.3) I hope this help --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes d'Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------