Re: Online Row Level Locking

> The problem seems to be errors relating to the fact that Online locks > adjacent rows in a table when a row is locked. Does anyone have any > suggestions or comments about the best way for the applications to work > around this? There is considerable activity occurring on the system, and > the potential for lockouts happening is high. Any thoughts would be > appreciated. Additional details as soon as I get them (The system is in > Cincinnati and I am in Wash.DC). Thanks. > Rory, When you create a table in online you specify row or page level locking, It sounds like they may be doing page level locking which is the default for online. Row level locking may require more systems resources so there is a trade off. Also, look at the SET ISOLATION and SET LOCK MODE commands. These help you in tuning an application to work with locking. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Control you Informix database security with DB Privileges # #############################################################################