| Parameters | Description | Default value |
|---|---|---|
| LOG_LEVEL | The level of logs to be left by ProSyncManager, which can be changed dynamically. (ERROR, WARN, INFO, DEBUG, TRACE) | INFO |
| LOG_DIR | The directory where ProSyncManager will leave logs. | ${PRSMGR_HOME}/logs |
| LOG_COMPRESS | Determines whether to compress previous logs (Y, N) | Y |
| LOG_MAX_FILE_SIZE | The maximum size of individual log files. It is in bytes and can be set using GB/MB/KB. | 1GB |
| LOG_MAX_HISTORY | The number of days between log files to keep, with older files deleted. | 30 |
| LOG_TOTAL_SIZE_CAP | The upper limit for the sum of the total size of all log files, with older files deleted. It is in bytes and can be set using GB/MB/KB. | 30GB |
| IC_SELECT_THREAD_COUNT | The number of threads used for data comparison during the consistency check operation. | 8 |
| IC_APPLY_THREAD_COUNT | The number of threads used for data correction during the consistency check operation. | 8 |
| IC_QUEUE_SIZE | The parameter for memory management of the consistency check and means the maximum value of statements to be held in the stream that reads/writes the sql file. If the users allow a value that is too large, it will affect the performance (resources) of the ProSync Manager by increasing the number of statements accumulated in memory when SQL file creation is slow, so set the appropriate value according to the environment. (1 - 2147483647) | 128 |
| IC_DOWNLOAD_PATH | The parameter of the verification function, where the sql file of the verification result will be saved. | ${PRSMGR_HOME]/verify |
| IC_CONNECTION_TIMEOUT | The connection timeout for trying to connect to JDBC.(0 - 2147483647 seconds) If set to 0 seconds, the connection wait is performed without timeout. | 300 |
| IC_READ_TIMEOUT | Query Timeout to wait for a response when a query is sent to the server. (-1 - 2147483647 seconds) If set to a positive integer, it will wait for timeout (seconds). If it is 0 or a negative value, it will wait indefinitely for the query response. | 1800 |
| IC_SERVICE_THREAD_CNT | The number of threads to perform consistency checks simultaneously. All values greater than 0 are allowed, but allowing too many threads affects the performance (speed and resources) of the ProSync Manager, so set the appropriate value according to the users environment. | 10 |
| IC_SERVICE_DOWNLOAD_THREAD_CNT | The thread pool size used for downloading SQL files after the consistency result.0All larger values are allowed, but allowing too many threads affects the performance (speed and resources) of the ProSync Manager, so set the appropriate value according to the environment. | 5 |
| IC_SERVICE_APPLY_THREAD_CNT | The thread pool size used for the matching correction operation.Maximum {setting value} * 5 occupies the TAR DB Connection. All values greater than 0 are allowed, but allowing too many threads may affect the performance (speed and resources) of the ProSync Manager, so set the appropriate value according to the users environment. | 5 |
| IC_USE_UNICODE_ORDER | If the charset is not UTF, the sort order of special characters such as Chinese characters may be different. If this option is true, it changes the sort order to unicode when sorting by columns that are interpreted as Strings, such as char/varchar, in non-UTF environments.(This has an effect if the KEY contains a char/varchar column or if the table contains such a column without a KEY) | false |
| IL_EXTRACT_PARALLEL | The Parameter of the initial load function, which determines whether to parallelize extraction.(Y|N) | N |
| IL_INSERT_PARALLEL | The parameter of the initial load function, which determines whether to parallelize insertion.(Y|N) | N |
| IL_LOCK_TIMEOUT | The parameter of the initialization function, the time to try to lock the table in srcDB during initialization.(1 - 2147483647 seconds) | 10 |
| IL_LOG_PATH | The parameter of the initialization function, the location to save the log file of the initialization.(1 - 2147483644 seconds) | ${PRSMGR_HOME}/etl |
| PEPODB_USERNAME | The user name to connect to repoDB | repo_user |
| REPODB_PASSWORD | The password of PEPODB_USERNAME to connect to repoDB. | password |
| REPODB_IP | The iP to connect to repoDB. | localhost |
| REPODB_PORT | The port to connect to repoDB. (0 - 65535) | 13852 |
| REPODB_DBNAME | The DB name to connect to repoDB. | prosyncmanager |
| JWT_VALID_TIME_MILLIS | jwt Token-related parameter, the valid time of the token. (1 - 9223372036854775807 milliseconds) | 7776000000 |
| JWT_REFRESH_TIME_MILLIS | jwt Token-specific parameter, the validity time of the refresh token. (1 - 9223372036854775807 milliseconds) | 31104000000 |
| DB_TIMEOUT_SECONDS | Timeout setting for query response to the control DB.(0:Infinite wait, 0 - 2147483647 seconds) | 5 |
| TOMCAT_LOG_LEVEL | Level of tomcat logs to deploy ProSyncManager.(ERROR, WARN, INFO, DEBUG, TRACE) | INFO |
| TOMCAT_LOG_DIR | Directory where tomcat logs will be located. | ${PRSMGR_HOME}/tomcat_logs |
| TOMCAT_LOG_COMPRESS | COMPRESSDetermines whether to compress old tomcat logs.(Y, N) | Y |
| TOMCAT_LOG_MAX_FILE_SIZE | Maximum size of individual tomcat log files in bytes and can be set using GB/MB/KB. | 1GB |
| TOMCAT_LOG_MAX_HISTORY | The number of days between tomcat log files to be retained. Older files will be deleted. | 30 |
| TOMCAT_LOG_TOTAL_SIZE_CAP | The upper limit for the total size of all tomcat log files. Older files will be deleted. | 30GB |
| RETENTION_JOB_TIME | Time to execute to remove the partition saving log data. (0 - 23) | 1 |
| RETENTION_EVENT | The event information to store for a period of time (-1: never, 0: only store information for the day, max 365) | 30 |
| RETENTION_ERROR | The error information to store for a period of time (-1: Never, 0: Save only today's information, max 365) | 30 |
| RETENTION_LONG_TX | The long tx Information to save (-1: Never, 0: Save only today's information, max 365) | 30 |
| RETENTION_RESOURCE | cpu/mem Usage information to save (-1: Disabled, 0: Saves only the current day's information, max 365) | 30 |
| RETENTION_STATISTICS | The number of synchronized dml/ddl information (-1: Disabled, 0: Saves only the current day's information, max 365) | 30 |
| RETENTION_TSN_DIFF | Time information to save the tsn Diff information. (-1: Disabled, 0: Saves only the current day's information, max 365) | 30 |
| RETENTION_SRC_TIME_MAP | Time information mapped to the tns. (-1: Disabled, 0: Saves only the current day's information, max 365) | 30 |