ECPSync

Synopsis

[SQL]    ECPSync=n

Description

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 in Using InterSystems SQL.

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 the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).