CDC General Questions

[Phil Frankford]

We are considering implementing CDC and have some general questions.

1) Can all applications tables be monitored by CDC?

2) What is the approximate added overhead?

3) What is CDC Plus and what does it buy?

4) Can the mainframe send CDC to another platform?

Thanks Phil

[RGBogan]

1.   all tables except for the CDC tables(base 2009, 2012 thru 2019).

2.  the biggest overhead for us was the logging of CDC.  If your logs are large, you may want to consider doing source/target to move the CDC logging to another MUF.  We did this with our 2 busiest MUFs.

3.  CDC Plus adds 8 more databases that you can spread the work around, 2012 thru 2019.  You can have more than one CDC base to pass only the tables you need to it…

4.  well,  CDC can’t, but the output from your CDCU application can.  We are using a 3rd party software package that allows communications to their server system, via a listener running on the mainframe.

 

Bob

[Kevin Shuma]

Phil,

 

I have replicated your questions and then provided a responses with a "==>"  prefix.

 

We are considering implementing CDC and have some general questions.

1) Can all applications tables be monitored by CDC?

==> Yes, as long as the tables are LOG=YES, RECOVERY=YES

 

2) What is the approximate added overhead?

==> Overhead variable and is based on how much maintenance activity is being captured.

         For most shops maintenance activity is a small percentage of request (10-15%)

         Overhead can be shifted from the PROD MUF for CDC activity to a special CDC replication MUF

            The CDC replication MUF does not reduce the overhead, but moves it out of the PROD MUF to a separate address             space 

 

3) What is CDC Plus and what does it buy?

==> CDC plus allows the user to separate the captured changes to different (max 9) CDC repository databases

            The separate repository databases allows the customer to separate captured changes by monitored table name so that             we can isolate changes in the target repository database according to  application function or security requirements.    

 

4) Can the mainframe send CDC to another platform?

==> CDC itself does not "send" data to other platforms -- it just captures the changes and stores them is a standard database table to be processed

==> CA provides a listener/applier process specific to Datacom MUF (zOS) to Datacom MUF (zOS)  movement (replication) thru MQ.  This is part of an Active/Query implementation.

==> There are 3rd parties (like Power Exchange, GT Software) that have tools that read the Datacom CDC database and forward the changes to off platform processes.    

 

 

Regards,

 

Kevin