Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    6

    Unanswered: Locks Exceeding on the Server

    I have a situation where one of our clients are encountering the problem where too many Locks are acquired on the Server and terminates the process when the limits are exceeded.

    The Locking on the tables is set to Row level. The application performs atomic saves (all or none)

    Any clues on what needs to be changed to over this problem. Any configurations, settings etc.,

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    There is a LOCKS parameter in the $ONCONFIG file
    also if it is a big load toy cal lock the table in the exclusive mode and then it will only use one lock

  3. #3
    Join Date
    Sep 2004
    Posts
    6

    Exclamation Locks Exceeding on the Server

    We have already thought about performing an Exclusive lock on the table, but that would limit other sessions from doing the saves in the application simultaneously (beats the purpose of data concurrency).

    Any alternate approaches?

    Is there a max limit to setting the Locks on the Server?

    I am knid of new to INFORMIX. Prompt feedback appreciated

    Thank you

    Rama

  4. #4
    Join Date
    Sep 2004
    Posts
    6

    Exclamation Locks Exceeding on the Server

    We have already thought about performing an Exclusive lock on the table, but that would limit other sessions from doing the saves in the application simultaneously (beats the purpose of data concurrency).

    Any alternate approaches?

    Is there a max limit to setting the Locks on the Server?

    I am kind of new to INFORMIX. Prompt feedback appreciated

    Thank you

    Rama

  5. #5
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Increase the LOCKS parameter in the $ONCONFIG file
    it is in $INFORMIXDIR/etc

Posting Permissions

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