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

Change Capture from Adabas Spanned Records

Change Capture from Adabas Spanned Records

Starting with Adabas 8.2.2, the Adabas ECCR can capture changes from Adabas spanned records.
A spanned record is a logical record that is composed of a single physical primary record and up to four physical secondary records. Each record is stored in a separate data storage block. The block size depends on the Adabas device type.
Before you start the Adabas ECCR, perform the following PowerExchange and Adabas configuration tasks that are required to capture change data from source files with spanned records:
  • In the PowerExchange Adabas ECCR JCL, add the following PARM to the EXEC statement:
    EXEC PGM=DTLCCADA,PARM=(ADA82)
    The ECCR JCL is usually in the PROCLIB member named
    prefix
    AD1EC, which was created during installation. If you do not include PARM=(ADA82), the ECCR does not capture changes for the sources files that contain spanned records.
  • Apply the following Adabas SAG ZAPs to your Adabas load libraries:
    • AU823101 (ADA823)
    • AU824072 (ADA824)
    • AU825047 (ADA825)
    • AU826017 (ADA826)
  • In Adabas, specify the following SRLOG=ALL parameter for the Adabas nucleus:
    ADARUN SRLOG=ALL
    The SRLOG=ALL parameter causes Adabas to log before and after images for the entire primary record and the entire secondary records that contain changes to the PLOG data sets.
  • In Adabas, verify that record spanning is explicitly enabled for each Adabas file.
To check if an Adabas file contains spanned records, you can generate a report by using one of the following Adabas utilities:
  • If you use Adabas 8.2.3 or later, use the ADAREP utility to generate a database report that indicates whether the Spanned Record option is set for the database and whether a specific file contains spanned records.
  • Use the ADADBS utility SPANCOUNT function to display counts of primary records, secondary records, and non-spanned records for a file.

0 COMMENTS

We’d like to hear from you!