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

ETID_DATE Parameter

ETID_DATE Parameter

Controls whether the Adabas ECCR entirely replaces values that start with x'40' in the ETID field in 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.
When processing PLOG files, the ECCR performs the following steps:
  • Uses the ADASEL utility to expand the PLOG files to read Insert, Update, and Delete change records.
  • Reads the expanded PLOG files to get the Begin UOW and End UOW records to determine where UOW commits occur, and then writes this commit information to a temporary file that PowerExchange uses internally.
  • Matches the change records from the PLOG files to the commit records in the temporary PowerExchange file by using several fields, including the ETID field that stores the userid.
In the ADASEL-expanded PLOG files, the ETID userid can be expressed as either an actual user ID or a timestamp value. The ADASEL utility can produce ETID timestamp values in hexadecimal timestamp format, for example, x'400015321F404040', or replace timestamp values entirely with x'40' values, for example, x'4040404040404040'.
The ADASEL utility writes internally generated values that begin with x'40' to the ETID field in the PLOG records, unless the user application provides a specific user ID in the call to Adabas. You can use this parameter to cause the ECCR to write the internally generated values as all x'40' values.
ETID_DATE=(
Y
|N}
  • N
    . The ECCR replaces ETID values that begin with x'40' entirely with x'40' values when writing these ETID values to the temporary PowerExchange commit file. This behavior is acceptable if the ADASEL utility produces ETID timestamp values as all x'40' values in the expanded PLOG files. The ECCR can still match the change records in PLOG files with the commit records in the PowerExchange commit file to determine where UOW commits occur.
    However, if the ADASEL-expanded PLOG files contain ETID values in hexadecimal timestamp format or in ADASEL-generated internal format and the ECCR replaces these values with all x'40' values, the ECCR will not be able match the change records from the PLOGs to the commit records. In this case, UOWs might remain open, causing the PowerExchange Logger for z/OS to generate many spill files. Also, spill file allocation errors and CDC session failures might occur.
  • Y
    . The ECCR does not replace ETID values that begin with x'40' entirely with x'40' values when writing these ETID values to the temporary PowerExchange commit file. The ECCR writes the values exactly as read from the expanded PLOG files to the PowerExchange commit file. Use this option if the ADASEL utility writes ETID values in hexadecimal timestamp format or in the ADASEL-generated internal format to the PLOG files. In these cases, this option can prevent a large number of outstanding UOWs, spill file allocation errors, and session failures.
Default is Y.

0 COMMENTS

We’d like to hear from you!