Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

CDC Override Options in the EDMKOVRD DD Data Set

CDC Override Options in the EDMKOVRD DD Data Set

You can enter the new //EDMKOVRD DD statement in the CICS startup procedure to specify CDC override options that enable or disable CICS/VSAM ECCR change data capture by VSAM data set type or for specific data sets. You can also set some options that override default processing of backout records for ESDS data sets.
To enable change data capture for ESDS data sets, you must add the //EDMKOVRD DD statement with the CAPTURE_ESDS=ON option. By default, change data capture is disabled for ESDS data sets.
In the EDMKOVRD DD statement or data set, enter any of the following options:
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 syncpoint 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=
data_set_name
[,
option
]…
To enter overrides for a specific VSAM source data set, specify the fully qualified data set named followed by one or more of the following optional options:
  • {CAPTURE|NOCAPTURE}
    . Enter CAPTURE to enable change data capture for the specified data set, or enter NOCAPTURE to disable change data capture for the data set. 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 also use a space between the options. 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.
If the CICS/VSAM ECCR is active when you set these options, issue the EDMC RESTART command to re-initialize the CICS/VSAM ECCR so that the ECCR can start using the updated CDC override options.
For more information, see the "CICS/VSAM Change Data Capture" chapter in the
PowerExchange CDC Guide for z/OS
.

0 COMMENTS

We’d like to hear from you!