maintain_replication_mqt_latency_table

Use this system parameter to allow the CDC Replication Engine for Db2® Database to communicate latency information to DB2® when you have configured the database to have its shadow tables (also known as Replication Maintained Materialized Query Tables or RMMQTs) maintained by this CDC Replication instance.

Version— CDC Replication Engine for Db2 Database version 10.2.1 Interim Fix 12 or later

If this system parameter has a value of true, the IBM® CDC for Db2 Database will perform the latency maintenance whenever there is at least one shadow table being targeted in the subscription.

The following conditions must be met in order for this system parameter to function correctly:

  • The database specified in the datastore must be Db2 for Linux®, UNIX and Windows version 10.5.4 or later. It must also be configured to support shadow tables. Consult your Db2 documentation for details on configuring this feature.
  • The SYSTOOLS.REPL_MQT_LATENCY table must have been created in Db2. See the Db2 for Linux, UNIX and Windows documentation for information regarding the creation of this table.
  • Only a single CDC Replication instance per database should have this parameter set true.
  • All shadow tables should be replicated by a single subscription
Applies to
Target datastores
Values
Set this parameter to one of the following values:
true
The current CDC Replication instance will provide latency information to Db2 for the shadow tables it replicates.
false
The current CDC Replication instance will not maintain latency information in the SYSTOOLS.REPL_MQT_LATENCY table.
Default Setting
false