Help Center/ GaussDB(DWS)/ Tool Guide/ DataCheck/ Configuring DataCheck/ Configuration of dbinfo.properties
Updated on 2025-01-09 GMT+08:00
View PDF
Share

Configuration of dbinfo.properties

The dbinfo.properties file contains a series of application configuration parameters, which are used to connect the source database and the destination GaussDB(DWS) database. The parameters in this file are general parameters.

Perform the following steps to configure the parameters:

  1. Open the dbinfo.properties file in the conf folder.
  2. Change the values of the parameters in the dbinfo.properties file according to the actual situation.

    For the description of the parameters in the dbinfo.properties file, see Table 1.
    • Parameter values are case-insensitive.
    • Do not modify any other parameter except the listed ones.

  3. Save the configuration and exit.
Table 1 Parameters in the dbinfo.properties file

Parameter

Description

Value Range

Default Value

Example

src.dbtype

Source database type
  • mysql
  • pg
  • dws_src

MySQL

src.dbtype =mysql

src.dbname

Source database name

N/A

sys

src.dbname=sys

src.ip

IP address of the source database

N/A

N/A

src.ip=100.xx.xx.47

src.port

Source database port

N/A

3306

src.port=3306

src.username

Source database username

N/A

root

src.username=root

src.passwd

Source database password

N/A

N/A

src.passwd=123456

dws.dbtype

Database type of the GaussDB(DWS) destination end

dws

dws

dws.dbtype=dws

dws.dbname

Name of the GaussDB(DWS) destination end

N/A

gaussdb

dws.dbname=gaussdb

dws.ip

IP address of the GaussDB(DWS) destination end

N/A

N/A

dws.ip=100.xx.xx.186

dws.port

Port of the GaussDB(DWS) destination end

N/A

8000

dws.port=8000

dws.username

Username of the GaussDB(DWS) destination end

N/A

dbadmin

dws.username=dbadmin

dws.passwd

Password of the GaussDB(DWS) destination end

N/A

N/A

dws.passwd=123456

config.sum.switch

Value check sum function switch
  • on
  • off

on

config.sum.switch=on

config.avg.switch

Average value function switch for value check
  • on
  • off

on

config.avg.switch=on

config.data.min.switch

Minimum value function switch for value check
  • on
  • off

on

config.data.min.switch=on

config.data.max.switch

Maximum value function switch for value check
  • on
  • off

on

config.data.max.switch=on

config.date.min.switch

Minimum value function switch for date check
  • on
  • off

on

config.date.min.switch=on

config.date.max.switch

Maximum value function switch for date check
  • on
  • off

on

config.date.max.switch=on

config.collate.switch

Indicates whether to enable a collate rule.

on: enable; off: disable.
  • on
  • off

on

config.collate.switch=on

config.dws.collate

Collate rule value: C, zh_CN, or en_US.
  • C
  • zh_CN
  • en_US

C

config.dws.collate=C
Parent topic: Configuring DataCheck