Skip to main content


Ensure that the server and client cache are in sync.


[SQL]    ECPSync=n

n is either 1 or 0. The default value is 0.


When ECPSync is enabled (n = 1), each time a SELECT statement is executed InterSystems IRIS® data platform forces all pending Enterprise Cache Protocol (ECP) requests to the database server. On completion, this guarantees that the client cache is in sync.

ECP is a distributed data caching architecture that manages the distribution of data and locks among a heterogeneous network of server systems. For further details, refer to Queries and ECP in the “Querying the Database” chapter.

Changing This Parameter

To set the desired value for ECPSync from the InterSystems Terminal, use the SetOption(“ECPSync”)Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change ECPSync with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab