ModifyDtsJobConfig Parameters - DTS Developer Reference - Data Transmission Service

Configure the Parameters parameter when calling ModifyDtsJobConfig to modify DTS task settings.

Parameter description

Parameters is a JSON string. Specify the following fields:

module

Module of the parameter. Valid values:
- 03: The Full Data Migration module for data migration or synchronization tasks.
- 04: The Incremental Write module for a data migration task.
- 07: The Incremental Write module for data synchronization tasks.
- 60: The synchronization module for Kafka-to-Kafka and SLS-to-ClickHouse tasks.
name

The parameter name, as listed in the following table.
value

The parameter value, as listed in the following table.

Parameter (name)	Configurable module (module)	Description (value)
source.column.encoding	03, 04, or 07	Character encoding of business data in the source Oracle database. Prevents garbled text from character set incompatibility. Valid values: default GB 2312 GBK GB 18030 UTF-8 UTF-16 UTF-32
sink.worker.type	03	Use the sink.worker.type and sink.bulk.copy.enable parameters to configure the data write mode for MySQL or PostgreSQL databases. To use bulk copy mode, set sink.worker.type to stream and sink.bulk.copy.enable to true. To use PreparedStatement executeBatch mode, set sink.worker.type to batch and sink.bulk.copy.enable to false.
sink.bulk.copy.enable	03
sink.batch.size.minimum	03	Minimum records a write thread writes per batch. Valid values: 0 to 1024.
sink.batch.size.maximum	03, 04, or 07	Full Data Migration module: Maximum records a write thread writes per batch. Incremental Write module: The number of transactions to merge. Valid values: 0 to 1024.
source.connection.idle.second	03, 04, or 07	Reconnection timeout for the source database. If DTS reconnects within this period, the task automatically resumes; otherwise it fails. Valid values: 0 to 86,400. Unit: seconds.
sink.connection.idle.second	03, 04, or 07	Reconnection timeout for the destination database. If DTS reconnects within this period, the task automatically resumes; otherwise it fails. Valid values: 0 to 86,400. Unit: seconds.
trans.hot.merge.enable	04 or 07	Enables or disables hot spot merging. Valid values: true: Enabled. false: Disabled.
sink.batch.enable	4, 7	Enables or disables batch data writing. Valid values: true: Enabled. false: Disabled.
source.filter.ddl.enable	04 and 07	Enables or disables DDL statement filtering. Valid values: true: Filters DDL statements and continues. false: Executes DDL statements normally.
sink.ignore.failed.ddl	04, 07	Enables or disables ignoring failed DDL statements. Valid values: true: Ignores failed DDL statements and continues. false: The task fails on DDL execution errors.
trans.size.maximum	04, 07	Transaction splitting threshold. Valid values: 0 to 1024.
dts.datamove.record.spouter.writers	07	Number of write threads. Valid values: 0 to 64.
selectdb.reservoir.group.by.target.schema	04 or 07	Batches write data by destination table name. Valid values: true: Enabled. false (default)
selectdb.reservoir.timeout.milliseconds	04 or 07	Write batching timeout, in milliseconds. Value range: 1000 to 10000. Default value: 5000.
sink.task.number	03, 04, 07, or 60	Number of write threads for the destination database. Higher values improve write performance for non-hotspot scenarios but increase database load. Value range: 1 to 64. Default value: 32

Example

Example in JSON format:

[
    {
        "module": "07",
        "name": "sink.connection.idle.second",
        "value": 60
    },
    {
        "module": "07",
        "name": "sink.batch.size.maximum",
        "value": 64
    }
]