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 IDMS Log-Based ECCR Parameters

Configuring IDMS Log-Based ECCR Parameters

Configure IDMS log-based ECCR parameters in the RUNLIB(ECCRIDLP) 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 ECCRIDLP member. You can accept or change these values.
The ECCRIDLP member can contain the following parameters:
LOGSID=
logsid
[NO_DATA_WAIT=
minutes
] [NO_DATA_WAIT2=
seconds
] ECCRNAME=PWXIDLEC DB_TYPE=IDL [ABRT_TERMINATION_BLOCK_COUNT={
number
|
10000
}] [CAPT_STATS={Y|
N
}] [CAPT_STATS_INTVL=
minutes
] [CAPT_STATS_TERSE={Y|
N
}] [COLDSTART={Y|
N
}] [ON_SUSPENSION_ERROR_CONTINUE={
N
|Y}] [REFRESH_ALLOWED={Y|
N
}] [RESTART_ADVANCE_ACTIVE=
number_of_records
]
The following table summarizes the ECCR parameters:
Parameter
Required or Optional
Description
LOGSID
Required
The LOGSID value that is specified in the DBMOVER configuration file.
This parameter is customized by the z/OS Installation Assistant.
NO_DATA_WAIT
Optional
The number of minutes that the ECCR waits after an end-of-log condition before starting the next log read. If the next log read returns no changes, the NO_DATA_WAIT2 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 an end-of-log condition before trying another log read. The NO_DATA_WAIT2 wait and retry cycle remains in effect as long as no changes are received.
This parameter can be customized by the z/OS Installation Assistant.
ECCRNAME
Required
The ECCR name.
DB_TYPE
Required
The database type, which must be IDL for IDMS.
ABRT_TERMINATION_BLOCK_COUNT
Optional
After the IDMS log-based ECCR encounters ABRT records in the IDMS journal that result from an IDMS ROLLBACK or ROLLBACK CONTINUE command, the number of subsequent IDMS journal blocks that the ECCR processes before it passes the job-level ABRT record to the PowerExchange Logger for z/OS. By processing these additional blocks, the ECCR can catch any additional updates from the job before the job-level ABRT record is logged. If the ECCR encounters additional updates, the job-level ABRT operation is canceled.
If this block count is too high, the ECCR might not resolve outstanding UOWs that contain ABRT records in timely manner, which prevents the journals from being freed. If you use small journals, you can decrease this parameter value to resolve these outstanding UOWs more quickly.
Valid values are 100 through 10000. Default is 10000.
CAPT_STATS
Optional
Controls whether PowerExchange writes ECCR statistics messages to the DTLLOG and DTLOUT data sets and WTO messages to the system operator console when the IDMS log-based ECCR finishes processing an IDMS log.
CAPT_STATS_INTVL
Optional
The interval, in minutes, for which the IDMS log-based ECCR collects and reports the number of inserts, deletes, updates, and commits that were captured from the change stream. The ECCR also reports the current point in the change stream.
CAPT_STATS_TERSE
Optional
Controls whether the IDMS log-based ECCR prints PWX-06153 statistics messages only for registered sources for which the ECCR captured changes.
COLDSTART
Optional
Controls whether the IDMS log-based ECCR cold starts or warm starts.
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 IDMS records that the ECCR uses for change capture processing.
RESTART_ADVANCE_ACTIVE
Optional
The number of change records that an active IDMS ECCR processes after a special restart UOW before writing another updated special UOW to the PowerExchange Logger.
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!