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

Adabas ECCR Parameter

Adabas ECCR Parameter

You can now specify the following optional parameter in the RUNLIB(ADAECRP1) member:
ETID_DATE={
N
|Y}
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.
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'.
With Adabas versions earlier than 8.3, the PowerExchange ECCR always sets the ETID timestamp values to all x'40' values if the ETID values begin with x'40'. This behavior is the default behavior.
Beginning with Adabas version 8.3, 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 prevent the ECCR from writing the internally generated values as all x'40' values.
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. Use this parameter to allow the ECCR to read the ETID values "as is" from the PLOGs so that these errors can be avoided.
Valid values:
  • 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.
  • 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 N.
For more information, see the "Adabas Change Data Capture" chapter of the
PowerExchange CDC Guide for z/OS
.
This parameter is also available in 9.6.1 HotFix 4. It is not available in 10.0.

0 COMMENTS

We’d like to hear from you!