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, see Queries and ECP.

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