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

SYSTEM_OPTIONS Parameters

SYSTEM_OPTIONS Parameters

In the SYSTEMS_OPTIONS substatement of the DEFINE statement, you can set PowerExchange Logger system parameters, such as those that control the Logger name, checkpoint processing, and tracing.
Syntax:
SYSTEM_OPTIONS   [LOGGER_NAME=
id
,]   [CHKPT_FREQUENCY=
nnnn
,]   [START_TRACE=Y|
N
,]   [SUFFIX=
n
,]   [TIMER_INTERVAL=
nnnn
,]   [TIME_CHKPT_FREQ=
nn
]
Parameters:
The following table describes the SYSTEM_OPTIONS parameters:
Parameter
Description
Valid Values
LOGGER_NAME
Specifies the PowerExchange Logger ID.
A string from one to four characters in length.
The following rules apply:
  • The value can begin with and contain alphanumeric characters and the characters #, @, and $.
  • Because other PowerExchange CDC components use this value to refer to the PowerExchange Logger, the value must match the LOGGER parameter in the PowerExchange Agent EDMSDIR options module and the LOG parameter on LRAPI CAPI_CONNECTION statement in the DBMOVER configuration member.
  • In a Post-Log Merge environment, all member Loggers must use the same LOGGER_NAME value.
CHKPT_FREQUENCY
Specifies the number of log records to process before taking a checkpoint.
A number from 1 to 2
31
-1.
Default is 10,000.
START_TRACE
Specifies whether the Logger trace is active.
For the trace output to be received, the EDMTRACE DD statement must be in the Logger JCL.
One of the following values:
  • Y
    for yes.
  • N
    for no.
Default is N.
The value Y causes additional overhead in the Logger. Enter Y only at the request of Informatica Global Customer Support.
SUFFIX
Specifies the unique suffix for a member in a Post-Log Merge group.
A unique number from 1 through 9.
TIMER_INTERVAL
Specifies how frequently the Logger performs its internal management operations, such as freeing unused virtual storage or detecting inactive tasks that need to be POSTed.
An interval in hundredths of seconds in the following range:
  • Minimum is 50 (.5 seconds).
  • Maximum is 6000 (1 minute).
Default is 100.
TIME_CHKPT_FREQ
Specifies how frequently time-based checkpoint records are created in a Post-Log Merge environment.
This parameter is used only when running Post-Log Merge.
The checkpoint frequency expressed in number of elapsed TIMER_INTERVAL periods.
This number must be in the following range:
  • Minimum is 5.
  • Maximum is 60.
Default is 30.
If you use the default TIMER_INTERVAL value of 100 hundredths of a second with the default of 30 for this parameter, a time-based checkpoint record is written every 30 seconds (100 * 1/100 * 30).
Usage Notes:
You must specify at least one parameter.
If you specify multiple parameters, use a comma (,) as a separator character. Do not put a comma at the end of the last parameter.

0 COMMENTS

We’d like to hear from you!