Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Unanswered: Replication error sql=-244 db_isam=-107

    I am running IDS10 FC6 on Linux platform.

    One of my table which receives high updates and select is giving sql error code -244, isam=-107 very frequently. error comes when select statement is executed on this table.

    I made sure there is no other process locking the record.

    When i turned off the replication error also goes. So i wanted to understand does INformix uses any lock on either node during replication.

  2. #2
    Join Date
    May 2006
    Posts
    12
    Hello,

    Kindly use the statement "SET LOCK MODE TO WAIT" For bulk updates

    and also check lock level in onconfig file.

  3. #3
    Join Date
    Jan 2010
    Posts
    2
    We can not put set lock mode to wait as it is impacting performance, system will stop access to these rows.

    My queries is why replication is causing these locks to last longer. As I understand replication shd not put or cause the locks to last longer on source node.

Posting Permissions

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