When you call the ConfigureDtsJob operation to configure a data migration or data synchronization task, you can set the DataCheckConfigure parameter based on your requirements.
Parameters
The data type of the DataCheckConfigure parameter is String, and the value must be specified in the JSON format. The following table describes the parameters nested within the DataCheckConfigure parameter.
Parameter | Type | Description |
---|---|---|
dataCheckDbList | String | The objects whose data is to be verified. The value must be a JSON string. |
fullDataCheck | Boolean | Specifies whether to perform a full data verification task. Valid values: true and false. |
fullCheckModel | Integer | The mode of the full data verification task. Valid values:
|
fullCheckFixData | Boolean | Specifies whether to replace the inconsistent data. Valid values: true and false. Default value: false. Note For example, you set this parameter to true. If the destination database has data that is inconsistent with the data in the source database, the data values of the destination database are replaced with those of the source database. |
fullCheckRatio | Integer | The sampling ratio of the full data verification task. Valid values: integers from 10 to 100. Unit: percent. Note This parameter is required if the fullCheckModel parameter is set to 1. |
checkMaximumHourEnable | Integer | Specifies whether to configure a timeout period for the full data verification task.
Note This parameter is required if the fullCheckModel parameter is set to 1. |
checkMaximumHour | Integer | The timeout period of the full data verification task. Valid values: integers from 1 to 72. Countdown begins the moment the full data verification task is started. If the task is not complete within the specified timeout period, the task is forcibly stopped. |
fullCheckReferEndpoint | String | The benchmark for full data verification. Valid values:
|
fullCheckMaxReadRps | Integer | The maximum number of data rows that are read per second. Valid values: integers from 0 to 9007199254740991. |
fullCheckMaxReadBps | Integer | The maximum number of bytes that are read per second. Valid values: integers from 0 to 9007199254740991. |
dataCheckNoticePhone | String | The mobile number of the alert contact for a full or incremental data verification task. If an alert is triggered for a verification task, a text message is sent to notify the alert contact. |
fullCheckErrorNotice | Boolean | Specifies whether to trigger an alert if the full data verification task fails. Valid values: true and false. Note For example, you set this parameter to true. If the full data verification task fails, an alert is triggered. |
fullCheckValidFailNotice | Boolean | Specifies whether to trigger an alert if inconsistent data is detected by the full data verification task. Valid values: true and false. Note For example, you set this parameter to true. If the number of inconsistent data entries detected by the full data verification task is greater than or equal to the threshold that you specified, an alert is triggered. |
fullCheckNoticeValue | Integer | The alert threshold for inconsistent data entries detected by the full data verification task. Note This parameter is required if the fullCheckValidFailNotice parameter is set to true. |
incrementalDataCheck | Boolean | Specifies whether to perform an incremental data verification task. Valid values: true and false. |
incrementalCheckErrorNotice | Boolean | Specifies whether to trigger an alert if the incremental data verification task fails. Valid values: true and false. Note For example, you set this parameter to true. If the incremental data verification task fails, an alert is triggered. |
incrementalCheckValidFailNotice | Boolean | Specifies whether to trigger an alert if inconsistent data is detected by the incremental data verification task. Valid values: true and false. Note For example, you set this parameter to true. If the cumulative number of inconsistent data entries detected by the incremental data verification task in several statistical periods is greater than or equal to the threshold that you specified, an alert is triggered. |
incrementalCheckValidFailNoticePeriod | Integer | The statistical period of an alert on inconsistent data entries detected by the incremental data verification task. Valid values:
Note This parameter is required if the incrementalCheckValidFailNotice parameter is set to true. |
incrementalCheckValidFailNoticeTimes | Integer | The number of statistical periods of an alert on inconsistent data entries detected by the incremental data verification task. Note This parameter is required if the incrementalCheckValidFailNotice parameter is set to true. |
incrementalCheckValidFailNoticeValue | Integer | The alert threshold for inconsistent data entries detected by the incremental data verification task. Note This parameter is required if the incrementalCheckValidFailNotice parameter is set to true. |
incrementalCheckDelayNotice | Boolean | Specifies whether to trigger an alert on the data latency of the incremental data verification task. Valid values: true and false. Note For example, you set this parameter to true. If the cumulative latency of the incremental data verification task in several statistical periods is greater than or equal to the threshold that you specified, an alert is triggered. |
incrementalCheckDelayNoticePeriod | Integer | The statistical period of an alert on the data latency of the incremental data verification task. Valid values:
Note This parameter is required if the incrementalCheckDelayNotice parameter is set to true. |
incrementalCheckDelayNoticeTimes | Integer | The number of statistical periods of an alert on the data latency of the incremental data verification task. Note This parameter is required if the incrementalCheckDelayNotice parameter is set to true. |
incrementalCheckDelayNoticeValue | Long | The alert threshold for the data latency of the incremental data verification task. Unit: seconds. Note This parameter is required if the incrementalCheckDelayNotice parameter is set to true. |