SQDCONF - connect_cdc_sqdata - Latest

Connect CDC (SQData) Utilities

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) Utilities
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:17:45.575795

Connect CDC (SQData) uses different methods of capture and storage of transient data depending on the source Datastore.

The Db2 , Db2/LUW (UDB) and Oracle Relational Capture agents use native recovery logs for capture and the proprietary CDCStore Storage Agent to manage transient data.

The IMS TM Exit capture is configured using the SQDXPARM utility while the IMS Log Reader Capture uses SQDconf and the VSAM capture is configured using VSAM Cluster parameters. The Keyed File Compare Capture uses simple JCL. All use z/OS System LogStreams to manage the transient data.

The SQDconf utility program performs three primary functions for Capture, Storage and Publisher agents:

  • Creates and maintains configuration files
  • Controls their operation
  • Displays operational status
The sections below identify the Source capture agent type where appropriate and include options that may apply to more than one type unless explicitly noted. The source specific Capture agent reference manuals include both SQDconf syntax and examples:
  • Db2 z/OS
  • Db2/LUW (UDB)
  • IMS z/OS
  • Oracle
  • VSAM z/OS
  • Keyed Files

This document contains the following sections:

  • Using Maintenance Commands to create, display and modify configurations for Capture, Publisher and Storage agents.
  • Using Control Commands to manage the implementation, activation and operation of the agents.
  • Execution of the Utility on z/OS and other platforms
  • Documentation describing z/OS System LogStreams is available from IBM
  • Operational considerations