Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Configuring a Parameter File for SAP HANA CDC

Configuring a Parameter File for SAP HANA CDC

Include the PARMFILE parameter in the HANA CAPI_CONNECTION statement to specify the SAP HANA CDC configuration file. This file contains parameters that control the maximum number of records that PowerExchange reads in a CDC read cycle and that override some of the parameters specified in the HANA CAPI_CONNECTION statement in the dbmover configuration file.
The SAP HANA configuration file has the following format:
MAXREADSIZE=
records
PROGRESS={Y|
N
}
parameter overrides
The configuration file must include the following parameters:
MAXREADSIZE=
records
Specify the number of SAP HANA records to process in a read cycle. This number can reduce the size of a UOW and improve the throughput of large source tables.
PROGRESS={Y|
N
}
To enable the MAXREADSIZE parameter, set PROGRESS to Y.
Default is N.
In addition to the required parameters, you can use the parameter file to override the following parameters in the CAPI_CONNECTION HANA statement:
  • TRANSACTIONSIZE
  • FETCHSIZE
  • LOGCLEAR
  • TIMEOUT
  • LOGLEVEL
  • ONDATATRUNC
  • SSL
If you use the configuration file to override CAPI_CONNECTION settings, the log file shows both the override and original values of each parameter.

0 COMMENTS

We’d like to hear from you!