Configure IMS log filter exit - 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 edition
2024-09-05
Last publish date
2024-09-05T15:00:09.754973

The IMS Log Filter Exit provides for extensive of filtering of the captured data. A sample Filter Exit program can be found in the distribution SAMPLIB member IMSCUFX1. This module is written in assembler and requires clear understanding of its function before it is modified. Precisely recommends consultation with Precisely https://www.precisely.com/support prior to making any modifications.

To configure one or more IMS log filter exit
  1. Review the SAMPLIB member IMSCUFX1 to determine if any changes are desired. The supplied sample module should be adequate for all scenarios.
  2. Use SAMPLIB member IMSCUFX1 assemble and link the IMSCUFX Filter exit.
  3. Use the SQDCONF utility and the modify command, specify the --Filter-exit=[<member_name> | ''] where <member_name> is IMSCUFX unless something other than the SAMPLIB member is used.
    Example: Add the Filter Exit module name to an existing IMS Log Capture configuration
    sqdconf modify imscdc.cab
                --Filter-exit=IMSCUFX 
  4. Add both the UFXIN and UFXOUT DD statements to the IMS Log Reader Capture SQDIMSC Job or Started Task and specify using both default and explicit specification the IMS DBD that will be excluded or included by the Capture.
    Example: Exclude from capture all IMS DBD's, except those whose DBD Names begin with the letters DBBA and DBBB and DBBC by adding the following DD names and parameters to the desired IMS Log Reader Capture.
    //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 DCB characteristics of the two DD statements:
UJXIN RECFM=FB or VB with an LRECL from 40 to 256 bytes
      UJXOUT RECFM=FBA,LRECL=133