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.