Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: URGENT - Informix DB 7.31. Tables gets locked for multiple Users

    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

  2. #2
    Join Date
    Apr 2004
    Location
    Brussels
    Posts
    57
    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 ?
    Yves & Willy

  3. #3
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •