Hi,
My DB is 7.31 Informix.
I have web application in which the transaction is read uncomitted. It is required that the transaction be read uncomitted.
When two users try to use the application, the table gets locked. So it stops the rest of the things.

Please let me know the solution for the same.

Rgds,
Lokesh

Hi,

- are you saying that the web application do "set isolation to dirty read" and it still locks the table ?
- what kind of locks is there on the table ? (onstat -k)
- what lock level is the table ?

Hi,

Please, check lock mode of tables.
Run select * from systables where locklevel = 'P' and tabid > 99.
If exist tables, then run alter table xxxxxx lock mode (row).

Gustavo.