Combine filter, feed and job exits - 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
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

Complex environments that include both BMP and DL/I Batch processing may require the use of both the Filter, Feed and Job Exits. For example, one IMS application may use DL/I Batch processing in its schedule, requiring the interruption of on-line processing. All other IMS applications may use only concurrent MPP and BMP processing and thus not require a "batch schedule" in the traditional sense.

This use case will make use of two IMS Log Reader Captures and Publishers, one pair for the mixed mode application and another for all other IMS applications.

Both the Filter Exit and the JOB Exit in the distribution SAMPLIB will support this mode of operation without modification using only the additional Exit DD statements in two different IMS Log Reader and zLOG Publisher Jobs or Started Tasks:

Example:

  1. An IMS Log Reader Capture started task IMSCDCA will capture all IMS application processes (MPP and BMP) except for those from the mixed mode application BBB, whose IMS DBD's begin with the letters DBBA and DBBB and DBBC. This will be accomplished by simply adding the Filter Exit DD statements and parameters to the Started Task JCL:
    //UFXIN DD * Filter exit input
    DEFAULT=INCLUDE
    * Add a DB statement for each applicable database to be excluded.
    DB=DBBAnnnn,EXCLUDE
    DB=DBBBnnnn,EXCLUDE
    DB=DBBCnnnn,EXCLUDE
    /*
    //UFXOUT DD SYSOUT=*

    The data captured by IMSCDCA will be published downstream by a single Publisher, IMSPUBA to all Engines subscribing to data from all applications other than the mixed mode application BBB.

  2. A second IMS Log Reader Capture started task IMSCDCB will capture only the databases used by application BBB using the Filter Exit. It will also accommodate the DL/I Batch processing in application BBB using the Feed and Job Exits, ensuring that changes made by DL/I Batch jobs from only mixed mode application BBB DL/I Batch Jobs whose names begin with the Letters JBBA, JBBB and JBBC.
    The IMSCDCB Log Capture configuration CAB file will be configured for both Filter, Feed and Job Exit processing. Add the Feed LogStream, Filter and Job Exit modules:
    sqdconf modify IMSCDCB.cab
    -\-add-feed=sqdata_batch_feed_log_stream
    -\-filter-exit=IMSCUFX
    -\-job-exit=IMSCUJX
    The Filter and Job Exits will also require adding their respective DD statements to the IMSCDCB Started Task JCL:
    //UFXIN DD * Filter exit input
    DEFAULT=EXCLUDE
    * Add a DB statement for each applicable database to be excluded.
    DB=DBBAnnnn,INCLUDE
    DB=DBBBnnnn,INCLUDE
    DB=DBBCnnnn,INCLUDE
    /*
    //UFXOUT DD SYSOUT=*
    //*
    //UJXIN DD * Job exit input
    DEFAULT=EXCLUDE
    JBBA*,INCLUDE
    JBBB*,INCLUDE
    JBBC*,INCLUDE
    /*
    //UJXOUT DD SYSOUT=*
Note:
  • The two Capture/Publishers pairs will be configured as two independent Started Task pairs sharing only a common Capture Controller Daemon and source IMS OLDS/SLDS. Each will utilize their own System LogStream as well for transient storage of the Captured data prior to Publishing.
  • A minimum of two Apply Engines are required. One subscribing to the IMSPUBA publisher and the other IMSPUBB publisher. Both publishers will accommodate as many Engines as necessary, for example one Engine per source application captured by IMSCDCA.