add (zLog) - 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

The configuration file must be updated by adding an entry for each target Engine using the add command.

Syntax
sqdconf add <cab_file_name>
--key=<name>
--datastore=<url>
[--active | --inactive]
Keyword and Parameter Descriptions
Keyword Description
<cab_file_name> Must be specified and must match the name specified in the previous create command.
--key=<name> Source object name. That will be the VSAMDD in the CICS File Control Table (FCT) for the VSAM Capture and the RECALIAS parm from the Keyed FIle Compare Capture. The IMS Log Captured provide more flexibility:
  • <DBD> | < DBD.segment> Short system name for IMS Database Description and Segment as defined in IMS.
  • < DBD.Area> Short system name for IMS Database Description and Area as defined in IMS.
  • < DBD.Partition> Short system name for IMS Database Description and Partition as defined in IMS.
  • < PSB.DBD> Short system name for IMS PSB and Database Description as defined in IMS.
  • < SSID.DBD> Short system name for IMS Source System ID and Database Description as defined in IMS.
    Note: When used with TM Exit Capture, must be a subset of the Object Source Routing provided in the XPARM.
--datastore=<url> | -d <url> While most references to the term datastore describe physical entities, a datastore URL represents a target subscription and takes the form: cdc://[localhost]/[<agent_alias>]/<subscriber_name> where:
  • <host_name> - Optional, typically specified as either cdc:///... or cdc://[localhost | localhost IP]... since we are describing the server side of the socket connection.
  • <agent_alias> - Optional, the alias name assigned to the Capture/Publisher agent and must match the <agent_name> defined in the Controller Daemon sqdagents.cfg configuration file. Engine scripts will use the <agent_alias> when specifying the source "URL" and also on sqdmon <agent_name> display commands.
  • <target_name> Required, the subscriber name presented by a requesting target agent. Also referred to as the Engine name, the name provided here does not need to match the one specified in a local Controller Daemon sqdagents.cfg configuration file.
[--active | --inactive] Mark a table as active or in-active for capture. The table will remain in the current state until the capture is stopped, applied and re-started. The default is --inactive.
Note:
  • It is important to develop a standard for how Datastores also known as target subscriptions will be identified, particularly if a large number of Datastores will be defined.
  • --key - Precisely recommends using the DBD Name for each IMS DBD when using the IMS TM Exit Capture because the XPARM can accommodates Subset Routing where wild cards may have been specified.
  • The use of the --key parm to effectively Filter the data based on various IMS database attributes can also be supplemented by use of the IMS Log Reader Capture Filter Exit.