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 the Adabas ECCR Parameters

Configuring the Adabas ECCR Parameters

Configure the Adabas ECCR parameters in the RUNLIB(ADAECRP1) member to which the DTLCACFG DD statement in the ECCR JCL points.
Based on your input during installation, the z/OS Installation Assistant adds values for some parameters to the ADAECRP1 member. You can change these values if necessary.
The ADAECRP1 member can contain the following parameters:
DBID=ADA
collection_id
DB_TYPE=ADA ECCRNAME=AD1EC [NO_DATA_WAIT=
minutes
] [NO_DATA_WAIT2=
seconds
] [COLL_END_LOG=<xx_collendlog_ada>] [ADASEL_DSN=
data_set_name
] [CAPT_STATS={Y|
N
} [CAPT_STATS_INTVL=
minutes
] [CAPT_STATS_TERSE={Y|
N
}] [COLDSTART={Y|
N
}] [ETID_DATE={
Y
|N}] [IGNORENOCHANGEUPDATES={Y|
N
}] [ON_SUSPENSION_ERROR_CONTINUE={Y|
N
}] [REFRESH_ALLOWED={Y|
N
}]
The following table summarizes the Adabas ECCR parameters:
Parameter
Required or Optional
Description
DBID
Required
The collection ID for the Adabas source.
This parameter is customized by the z/OS Installation Assistant.
DB_TYPE
Required
The database type, which must be ADA for Adabas.
ECCRNAME
Required
The Adabas ECCR name.
ETID_DATE
Optional
Controls whether the Adabas ECCR entirely replaces values that begin x'40' in the ETID field of the ADASEL-expanded PLOG files with all x'40' values when writing the ETID values to the temporary PowerExchange file that stores commit information for source UOWs. The x'40' values represent blank spaces.
NO_DATA_WAIT
Optional
The number of minutes that the Adabas ECCR waits after processing all PLOG entries in the PCAT file before next checking for new PLOG entries to process. If the ECCR finds no new entries, the NO_DATA_WAIT2 wait interval takes effect.
This parameter can be customized by the z/OS Installation Assistant.
NO_DATA_WAIT2
Optional
After the NO_DATA_WAIT interval is no longer in effect, the number of seconds that the ECCR waits after processing all PLOG entries in the PCAT before checking for new PLOG entries. If COLL_END_LOG is set to 0 and NO_DATA_WAIT is set to a value greater than 0, the NO_DATA_WAIT2 wait and retry cycle remains in effect as long as no new entries are found.
This parameter can be customized by the z/OS Installation Assistant.
COLL_END_LOG
Optional
Controls whether the ECCR must process a specific number of PLOGs before it can shut down. Used in conjunction with NO_DATA_WAIT and NO_DATA_WAIT2.
This parameter can be customized by the z/OS Installation Assistant.
ADASEL_DSN
Required
The name of a data set that contains the Adabas ADASEL parameters.
CAPT_STATS
Optional
Controls whether PowerExchange writes ECCR capture statistics messages to the DTLLOG and DTLOUT data sets and WTO messages to the system operator console when the Adabas log-based ECCR finishes processing a PLOG.
CAPT_STATS_INTVL
Optional
The interval, in minutes, for which the Adabas log-based ECCR collects and reports the number of inserts, deletes, updates, and commits that were captured. The ECCR also reports the timestamp in the log up to which changes were processed.
CAPT_STATS_TERSE
Optional
Controls whether the Adabas log-based ECCR prints PWX-06153 messages with capture statistics only for registered sources for which the ECCR captured changes.
COLDSTART
Optional
Controls whether the Adabas ECCR cold starts or warm starts.
IGNORENOCHANGEUPDATES
Optional
Controls whether the Adabas ECCR ignores records for which update operations did not change data.
ON_SUSPENSION_ERROR_CONTINUE
Optional
If you use the PWXUCREG utility to suspend and reactivate capture registrations, controls whether the ECCR ends or continues when a UOW that contains change records to be discarded or captured started at an invalid point in the change stream relative to the suspension window.
REFRESH_ALLOWED
Optional
Controls whether you can use the REFRESH command after adding or deleting capture registrations or after suspending or reactivating capture registrations with the PWXUCREG utilty. The REFRESH command refreshes the list of registered Adabas files that the ECCR uses for change capture processing.
If a parameter has a default value or is not required, it is marked as optional. A default value is the value that PowerExchange uses if the parameter is not defined. For some parameters, the z/OS Installation Assistant provides recommended values, which you can accept or change.
More detailed parameter descriptions follow.

0 COMMENTS

We’d like to hear from you!