Replicating temporal tables

InfoSphere® CDC for z/OS® supports the replication of temporal tables under the following conditions:

• The source datastores must be one of the following versions:
  • InfoSphere CDC for DB2® for LUW version 10.2 or later
  • InfoSphere CDC for z/OS version 10.2 or later
• The target datastores must be the following version:
  • InfoSphere CDC for DB2 for LUW 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 InfoSphere CDC 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