Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange Change Data Capture Introduction
  3. Part 2: CDC Components Configuration and Management
  4. Part 3: CDC Sources Configuration and Management
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: CDC for z/OS Troubleshooting
  8. Appendix B: DTL__CAPXTIMESTAMP Time Stamps

Configuring CICS for CDC

Configuring CICS for CDC

To capture changes that CICS transactions make to VSAM data sets, edit the JCL and startup procedures for the CICS region. Also define the CICS/VSAM ECCR programs and transaction to CICS.
  1. Edit the CICS JCL.
    1. Specify the PowerExchange LOAD library in the DFHRPL DD and STEPLIB DD statements.
      If you included the LOAD library in the MVS LNKLST concatenation, add the library to the DFHRPL DD only.
    2. Add the EDMPARMS DD statement. Include a DSN option that points to the PowerExchange Logger USERLIB library, for example:
      //EDMPARMS DD DISP=SHR,DSN=
      hlq
      .
      logger_name
      .USERLIB
      The
      hlq
      variable is the high-level qualifier that you specified at installation.
  2. To initialize the
    CICS/VSAM
    ECCR during the third stage of CICS initialization, add the EDMKOPER module name to the second part of CICS PLTPI list, after the DFHDELIM entry.
    Informatica recommends that you add EDMKOPER to the CICS initialization list to reduce the possibility of missing changes in a high-volume production environment. However, you can use the EDMC transaction with the INIT keyword to manually initialize the ECCR. For more information, see the
    PowerExchange Command Reference
    .
  3. Add the //EDMKOVRD DD statement to the CICS startup procedure to override default capture settings or to activate change data capture for ESDS data sets in an online CICS TS environment.
    In the //EDMKOVRD DD statement or in the data set to which the DD statement points, specify options that selectively enable or disable CDC by VSAM data set type or for individual VSAM data sets. You can disable CDC even for data sets that are registered for change capture. Also, you can specify options for handling backouts for recoverable ESDS data sets.
    Options are:
    CAPTURE_ESDS={ON|
    OFF
    }
    Enables or disables change data capture for ESDS data sets. You must explicitly enter ON to enable CDC for ESDS data sets. Default is OFF.
    CAPTURE_KSDS={
    ON
    |OFF}
    Enables or disables change data capture for KSDS data sets. Enter OFF if you need to disable CDC for KSDS data sets. Default is ON.
    CAPTURE_RRDS={
    ON
    |OFF}
    Enables or disables change data capture for RRDS and VRDS data sets. Enter OFF if you need to disable CDC for RRDS and VRDS data sets. Default is ON.
    CAPTURE_CMDT={
    ON
    |OFF}
    Enables or disables change data capture for CICS-maintained data tables. Enter OFF if you need to disable CDC for CICS-maintained data tables. Default is ON.
    BACKOUTRC={
    OVERRIDE
    |NOOVERRIDE}
    For recoverable ESDS data sets, controls whether to override the return codes from any other active exit programs that are invoked at the XFCLDEL global exit point prior to the PowerExchange EDMKLD
    nn
    exit program for processing backouts as logical deletions. Options are:
    • OVERRIDE
      . Override the return codes from any prior exit programs at the XFCLDEL global exit point with the UERCLDEL return code from the EDMKLD
      nn
      program.
    • NOOVERRIDE
      . Percolate the return codes from any prior exit programs at the XFCLDEL global exit point. In this case, the return code of a prior exit program might supercede the return code from the EDMKLD
      nn
      program. With this option, the ESDSFAIL option is ignored.
    ESDSFAIL={YES|
    NO
    }
    For recoverable ESDS data sets from which change data is captured, controls whether backouts are allowed to fail after a transaction abend or synpoint rollback. By default, the PowerExchange exit programs that you define at the XFCBOUT and XFCLDEL global exit points handle backouts as logical deletions with before and after images so that the change can be processed during CDC. If you capture change data from recoverable ESDS data sets, set this option to NO. If you enter ESDSFAIL=YES, backouts will fail with many error messages.
    If you specified BACKOUTRC=NOOVERRIDE, this option is ignored.
    DSN=
    dataset_name
    [,
    option
    ]…
    To enter optional overrides for a specific VSAM source data set, specify the fully qualified data set named followed by one or more of the following options:
    • {CAPTURE|NOCAPTURE}
      . Enter CAPTURE to enable change data capture for the specified data set, or enter NOCAPTURE to exclude the data set from CDC processing. If you specify NOCAPTURE, the BACKOUTOVERRIDE and BACKOUTFAIL options are ignored.
    • {BACKOUTOVERRIDE|NOBACKOUTOVERRIDE}
      . For a recoverable ESDS data set, controls whether to override the return codes from any other active exit programs that are invoked at the XFCLDEL global exit point prior to the PowerExchange EDMKLD
      nn
      exit program. Enter BACKOUTOVERRIDE to override the return codes from any prior exit programs with the UERCLDEL return code from the EDMKLD
      nn
      exit program. Enter NOBACKOUTOVERRIDE to percolate the return codes from prior exit programs. If you specify NOBACKOUTOVERRIDE, do not specify NOBACKOUTFAIL.
    • BACKOUTFAIL|NOBACKOUTFAIL}
      . For a recoverable ESDS data set, controls whether backouts are allowed to fail after a transaction abend or syncpoint rollback. Enter BACKOUTFAIL to allow backouts to fail, or enter NOBACKOUTFAIL to allow the PowerExchange exit programs that you define at the XFCBOUT and XFCLDEL global exit points to handle backouts as logical deletions with before and after images and continue CDC processing.
    If you enter multiple options, separate them from one another with a comma. Do not use a space instead. For example:
    DSN=EDM.VSAM.ESDS4,CAPTURE,BACKOUTOVERRIDE,NOBACKOUTFAIL
    You can use the options in the DSN statement to override the CAPTURE_
    vsam_source_type
    , BACKOUTRC, and ESDSFAIL settings for a specific data set only. To activate the override options, issue the EDMC REFRESH command.
  4. Verify that you use a unique CICS/VSAM ECCR name for each CICS region that connects to PowerExchange and that each ECCR name is also unique within a PowerExchange Logger group.
    PowerExchange uses an ECCR name for the following purposes:
    • As the member name to join the XCF group that the PowerExchange Logger uses
    • As part of the ECCR-UOW control information for each change record that the ECCR sends to PowerExchange Logger log files
    The default ECCR name is the CICS SYSID value that is specified in the SYSIDNT parameter in the CICS system initialization table (SIT).
    To override the default name, enter the INITPARM statement for the EDMKOPER module in the SIT or a SIT override:
    INITPARM=(EDMKOPER=’
    option
    ’)
    The following table lists the valid options and their substitution values:
    Option
    Substitution Value
    *SYSID
    The CICS SYSID value
    *JOBNAME
    The CICS job or started task name
    *APPLID
    The VTAM application control block (ACB) name
    1 through 8 alphanumeric characters
    No substitution
    When EDMKOPER processes the
    option
    value, it translates lowercase characters to uppercase characters.
    Informatica recommends that you use the CICS job or started task name as the ECCR name. This practice makes it easier to identify the ECCR in PowerExchange Logger messages and output.
  5. Define the CICS/VSAM ECCR programs and transaction to CICS.
    To perform this step, use the sample members in the PowerExchange SAMPLIB library for the supported CICS Transaction Server (TS) versions.
    The following table identifies these sample members:
    CICS TS Version
    Member Name
    5.1
    #CICSV68
    5.2
    #CICSV69
    5.3
    #CICSV70
    5.4
    #CICSV71
    5.5
    #CICSV72
    5.6
    #CICSV73
    6.1
    #CICSV74
    In each member name, the suffix
    nn
    corresponds to the second and third digits of the CICS TS internal release level for the CICS TS version.
    Copy the sample member for your CICS TS version, and then edit the copy.
    Use the CICS DFHCSDUP utility program or RDO commands to add the CICS/VSAM ECCR programs and transaction to the CICS system definition.
    By default, the transaction name is EDMC. However, you can use another name.
If you need to change the ECCR name, you must either cold start the CICS region or enter NEWSIT=YES in the EXEC PARM option of the JCL or in the SIT or SIT override.

0 COMMENTS

We’d like to hear from you!