Advanced configuration parameters

If necessary, you can set the following parameters in the connector.properties file.


Parameter	Description	Possible values
connectRetryCount	The maximum number of attempts to establish or reestablish a connection before giving up. By default, a single retry attempt is made. A value of `0` means that a retry won't be attempted.	Positive integer, default: `10`
connectRetryInterval	The time, in seconds, between connection retry attempts. The driver will attempt to reconnect immediately upon detecting a broken idle connection, and will then wait `connectRetryInterval` seconds before trying again. This keyword is ignored if `connectRetryCount` is `0`.	Positive integer, default: `10`
inDbTokenizationMaxBatchCountSelect	Number of batches which should be selected. A batch is a partial set of input or output rows in a job.	Positive integer, e.g. `1`
inDbTokenizationMaxBatchCountInsert	Number of batches which should be inserted.	Positive integer, e.g. `1`
inDbTokenizationBatchSizeSelect	Restricts the number of rows to be read at once. This number is then "one batch". It may also be incremented for faster reading, e.g. to `1000`.	Positive integer, e.g. `200`
inDbTokenizationBatchSizeInsert	Restricts the number of rows to be inserted at once. Here it may make sense to set the value to `1` if problems with inserting occur.	Positive integer, e.g. `200`
inDbTokenizationCountRowsInTables	If set to `true`, the number of lines in the source and destination tables is output in the log.	`true` or `false`
inDbTokenizationEmptyDestinationTable	If set to `true`, this option will try to empty the target table before inserting.	`true` or `false`
inDbTokenizationBatchLogInsertQuery	If set to `true`, the token values to be written to the database are logged in advance. Of course, this is for testing purposes only and should be removed later.	`true` or `false`
inDbTokenizationIgnoreDateErrors	If saving date tokens causes problems, it can be determined that a NULL value will be written to the field in case of an error. Set the parameter to `true` to activate this feature.	`true` or `false`
inDbTokenizationReplaceBinaryWithStaticByte	If this option is set to `true`, binary values are replaced with a static byte.	`true` or `false`
inDbTokenizationSkipPrimaryKeySorting	If set to `true`, sorting by Primary Key while reading the source table is skipped.	`true` or `false`
inDbTokenizationUseAlternativePrimaryKeyQuery	Only relevant for DB2: Option to use a different query for the Primary Keys, since these must be loaded dynamically from the DB configuration tables. DB2 11 on z/OS may have problems that could be solved by this alternative query. Set the parameter to `true` to activate this feature.	`true` or `false`
inDbTokenizationSingleSelectionQuery	If set to `true`, the source table is read completely in one query. (Then neither sorting nor primary-key query takes place.)	`true` or `false`