Querying data from a replicated database file

Replicated data is available to be read on either Db2® Mirror node. When the Db2 Mirror replication state is ACTIVE and the replication detail is REPLICATING, the data is being kept identical through synchronous replication. When the data is queried or read, Db2 Mirror processing is not involved because the necessary data is already local to the source node.

If the Db2 Mirror replication state is BLOCKED, you are running on the secondary node and Db2 Mirror replication is suspended. Users and applications are allowed to read data from replicated database files, but it is possible that the data within those files is no longer the same as on the primary node.

When running on the secondary node, if the Db2 Mirror replication state is ACTIVE and the replication detail is not REPLICATING, Db2 Mirror is in some stage of resynchronization. Until resynchronization completes, the data on the secondary node can be accessed, but that data may not be identical to the primary node because resynchronization has not completed.