Replicating temporal tables

Before you begin replicating temporal tables, you should ensure that the following prerequisites and considerations are satisfied.

IBM® CDC for Db2® Database supports the replication of temporal tables under the following conditions:

• The source datastores must be one of the following versions:
  • CDC Replication Engine for Db2 Database version 10.2 or later
  • CDC Replication Engine for Db2 for z/OS® version 10.2 or later
• The target datastores must be the following version:
  • CDC Replication Engine for Db2 Database version 10.2 or later
• Management Console version 10.2 or later.
• The databases for source datastores must be one of the following versions:
  • DB2® for z/OS version 10.1
  • DB2 LUW version 10.1 FP2
  • DB2 LUW version 10.1 with special build 29578
• The databases for target datastores must be one of the following versions:
  • DB2 LUW version 10.1 FP2
  • DB2 LUW version 10.1 with special build 29578
• No other applications should be modifying the temporal tables or the history tables on the target datastore.
• To replicate to temporal tables as a target, execute permission must be granted to CDC Replication users on a stored procedure:

  db2 grant execute on procedure SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY 
  to <cdc user>

For more information about replicating temporal tables, see see Replicating temporal tables