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.

Hello,

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

and also check lock level in onconfig file.

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.