CDCStore - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
ft:lastEdition
2024-09-05
ft:lastPublication
2024-09-05T15:00:09.754973

The CDCStore transient datastore is a proprietary memory mapped storage system managed by Connect CDC (SQData)'s relational captures. While on zOS, the Db2/z capture can also be located on any platform, not just the platform hosting the source data. In most non-mainframe environments, database servers will be dedicated systems where third party products are not allowed to operate. The capture/publisher and therefore CDCStore can be located near either the source or target databases and on a commodity platform where processing and data storage costs may be lower. CDCStore of course supports full restart/recovery regardless of where the failure occurs, on the source database platform, the Engine platform or in CDCStore itself.

The CDCStore temporary filesystem may contain sensitive data and must be secured. The owner should set permissions for the filesystem to restrict access.

The second feature that differentiates CDCStore from some other publishing frameworks is support for multiple target Engines utilizing the same captured data without requiring its duplication. The ability to manage both transient and near term storage provides flexibility in configuration since target Engines need not operate on precisely the same schedule or at the same performance levels. Precisely however recommends a second capture/publisher when those schedules include large windows where managing a large amount of transient data is less effective than simply mining the source database log a second time.