Reference Manual

10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring a Parameter File with Additional Parameters for the HANA CAPI_CONNECTION

You can create a parameter file that contains optional JDBC connection properties and certain optional PowerExchange parameters. Then specify the path and file name for this parameter file in the PARMFILE parameter of the HANA CAPI_CONNECTION statement in the dbmover.cfg file.

The parameter file has the following syntax:

DATABASE
  [JDBCPROPS=property1=value&property2=value&...]
;
OPTIONS
[MAXREADSIZE=records]
[PROGRESS={Y|N}]
[pwx_parameter_overrides]
;

In the DATABASE section, you can include JDBC connection properties, such as compress and encrypt, that are used for connections to the SAP HANA database. For more information about these properties, see JDBC Connection Properties in the SAP HANA documentation.

In the OPTIONS section, you can include additional optional PowerExchange parameters. The following parameters can only be specified in this parameter file:

MAXREADSIZE=records: The number of SAP HANA records to process in a read cycle. You can use this parameter to reduce the size of a UOW and to improve the throughput of large source tables.
PROGRESS={Y| N }: Controls whether the cycle progress is detailed in the log file. To show the cycle progress, specify Y.
Default is N.

You can also specify override settings for the following HANA CAPI_CONNECTION parameters:

FETCHSIZE

LOGCLEAR

LOGLEVEL

ONDATATRUNC

SSL

TIMEOUT

TRANSACTIONSIZE

If you use the parameter file to override existing parameter settingst, the log file shows both the override and original parameter values.

Example parameter file:

Enter JDBC properties under DATABASE, and enter the PowerExchange PROGRESS parameter under OPTIONS. Each section must end with a semicolon (;). For example:

DATABASE
  JDBCPROPS="autocommit=false&emptyTimestampIsNull=true&connectTimeout=6000&traceFile=traceFile.txt&traceOptions=CONNECTIONS"
;
OPTIONS
/*  MAXREADSIZE=55
  PROGRESS=Y
;

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

Configuring a Parameter File with Additional Parameters for the HANA CAPI_CONNECTION

Configuring a Parameter File with Additional Parameters for the HANA CAPI_CONNECTION