Hello ,
I'm orientating to CDC and have some questions needing clarification/advices
We are planning the CDC v11.4 deployment to following way:
- replication source is IBM Z/OS Db2 v12 - using CDC replication engine for Db2 remote source
- replication target is PostgreSQL - using the CDC replication engine FlexRep . Postgresql version need to be V9 or higher.
- Access server (CDC server) is considered to be Linux
Q1: Engine for source is planned to be installed to Access server, as MF contain only stored procedure. Are there some considerations of this
Q2: Do we need to install target engine to PostgreSQL DB server or can we install target replication engine also to Access server?
-- like presentation
CDC Architecture page 13, scraper and apply on CDC server
When configuring the target datastore - in our case replication engine (FlexRep) in CDC Access server and actual DB to connect in differet DB server (PostgreSQL). This should be possible
- V11.4 manual states
DataStores: Each datastore represents the database or target destination to which you want to connect
Database/URL: Specifies the name of the database or the Universal Resource Locator (URL) of the database server you want to connect to.
I assume we need the JDBC driver at target end to be used. Or does we need the JDBC driver in CDC server connecting to target DB?
The management console - we consider separate server for this, or is just workstation enough?
Q3: is it possible to install several MC contacting to same Access Server?
About High availability configuration
- Mainframe we have sysplex implemented providing DVIPA address to connect
- For Access server we consider cluster solution by using the hot-standby scenario
- MC - no considerations as we are connecting to cluster (virtual) ip of access server
About replication mode
Our target does not contain any tables as idea is to set up selected source tables to target by same schema.
- can we create the table to the target by using Refresh mode at initial startup or does it expect the tables are present?
When configuring the subscription it expects target tables are existing.
To create tables to target we need extract the DDLs from mainframe and run those at target. Then we will configure suvscription.
I found the best practise: Best Practice - Deployment Configurations for LUW
https://www.ibm.com/support/pages/ibm-data-replication-change-data-capture-cdc-best-practices#Best%20Practice%20-%20Deployment%20Configurations%20for%20LUW- is this information relevant for V11.4 deployment?
Please advice and comment
Best Regards
Markku Niemi
------------------------------
Markku Niemi
TietoEvry
Finland
------------------------------
#DataReplication#DataIntegration