Apply Parameters

APPLY_DML_ERR_REPORT_CNT

Number of retries to apply dml before leaving a log to report file.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	20
Class	Optional, Static
Range	0 - 100000

APPLY_NUM

APPLY_NUM specifies the number of the target database. It must be greater than or equal to 1. In 1:N topology, each apply process must be assigned a different number in sequential order (1, 2, 3...).

Parameter Format

Property	Description
Parameter type	Integer
Default Value	1
Class	Mandatory, Static
Range	1 - 1024

APPLY_REPORT_BACKUP_DIR

APPLY_REPORT_BACKUP_DIR specifies the directory where the report files of ext process are backed up. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

APPLY_REPORT_BACKUP_SIZE

APPLY_REPORT_BACKUP_SIZE specifies the maximum size of report backup files of ext process. If this limit is exceeded, the oldest report files in the directory are deleted.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	0
Class	Optional, Dynamic
Range	0 - 128G

APPLY_REPORT_DIR

APPLY_REPORT_DIR specifies the directory where the report files are stored. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

APPLY_REPORT_FILE_SIZE

APPLY_REPORT_FILE_SIZE specifies the maximum report file size of ext process. If a report file exceeds this limit, it is moved to the backup directory and a new report file is created.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	104857600
Class	Optional, Dynamic
Range	1M - 1G

APPLY_TO_DB

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Static
Range

APPLY_TO_REPORT

Determines whether to leave a log on the report file or not.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Static
Range

APPLY_TO_SAM

This parameter sets whether to log the statements that the APPLY process applies to the database into the SAM file. (Y/N)

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	N
Class	Optional, Dynamic
Range

BATCH_MEM_SIZE

This parameter determines the maximum value of LCR data to be stored for array bind.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	10485760
Class	Optional, Static
Range	1024 - UINT64_MAX

CHUNK_TOTAL_SIZE

Apply control thread stops receiving msg from ext when total chunk size of un-constructed exceeded.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	1073741824
Class	Optional, Static
Range	1 - UINT64_MAX

CLIENT_DRIVER

CLIENT_DRIVER specifies a path to the client library used to access a database. An absolute path must be specified. For Tibero, set a path to the libtbclnt.so file. And for Oracle, enter a path to the libclntsh.so file.

Parameter Format

Property	Description
Parameter type	path
Default Value	""
Class	Optional, Static
Range

COL_SAM_TEMPLATE

The COL_SAM_TEMPLATE parameter sets the path to the user-defined template file to be used when outputting column content for DML statements. It works when SQL_REDO_MODE is set to N. When logging DML statements, if column definitions are present in the COL_SAM_TEMPLATE, ProSync logs the column information to the SAM file according to that template format.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

CONN_MAX

CONN_MAX specifies the max number of connections between processes.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	128
Class	Optional, Static
Range	32 - 1024

DDL

DDL specifies DDL filtering options. For more information, refer to ProSync DDL RULE in Administrator's Guide.

Parameter Format

Property	Description
Parameter type	desc
Default Value	"(INCLUDE DEFAULT, TYPE=('ALTER TABLE','TRUNCATE TABLE'))"
Class	Mandatory, Static
Range

DISCARD_BACKUP_DIR

DISCARD_BACKUP_DIR specifies the directory where the discard files of ext process are backed up. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

DISCARD_BACKUP_SIZE

DISCARD_BACKUP_SIZE specifies the maximum size of discard backup files of ext process. If this limit is exceeded, the oldest discard files in the directory are deleted.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	0
Class	Optional, Dynamic
Range	0 - 128G

DISCARD_EC

List error codes to ignore during sync. (max 256 codes)

Parameter Format

Property	Description
Parameter type	desc
Default Value	"()"
Class	Optional, Static
Range

DISCARD_FILE_DIR

DISCARD_FILE_DIR specifies the directory where the discard files are stored. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

DISCARD_FILE_SIZE

DISCARD_FILE_SIZE specifies the maximum discard file size of ext process. If a discard file exceeds this limit, it is moved to the backup directory and a new discard file is created.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	104857600
Class	Optional, Dynamic
Range	1M - 1G

DISCARD_FILE_YN

Y to make a file of error codes that discarded during sync.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	N
Class	Optional, Dynamic
Range

DISCARD_YN

Toggle Discard feature.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	N
Class	Optional, Static
Range

DML_WAIT_TIMEOUT

This parameter determines retry interval when DML fails

Parameter Format

Property	Description
Parameter type	Integer
Default Value	60
Class	Optional, Static
Range	1 - 1048576

DSN_DIR

DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	""
Class	Optional, Static
Range

DSN_FILE

DSN_FILE specifies name of dsn file.

Parameter Format

Property	Description
Parameter type	String
Default Value	""
Class	Optional, Static
Range

GROUP_NUM

GROUP_NUM specifies the number of replay groups in multi-grouping mode.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	1
Class	Optional, Static
Range	1 - 20

KEY_VIOLATION_RETRY_CNT

The number of retries in a fault situation absence of primary key. Default value means infinite retries.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	0
Class	Optional, Static
Range	0 - UINT16_MAX

LCT_UPDATE_INTERVAL

This parameter decides how often to update the target meta tables PRS_COMMITTED_TX_LIST and PRS_LCT. The unit is in seconds.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	60
Class	Optional, Static
Range	1 - INT32_MAX

LEADING_PRS_USER

a leading prosync user in history topology

Parameter Format

Property	Description
Parameter type	String
Default Value	""
Class	Optional, Static
Range

LISTENER_PORT

LISTENER_PORT specifies the port number used by each process. All processes on the same machine must use different ports.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	7600
Class	Optional, Static
Range	1024 - 65535

LLOB_APPLY_MODE

LLOB_APPLY_MODE specifies how a LONG/LOB column is synchronized. If set to 'SKIP', the column is not synchronized; if set to 'SYNC', the column is synchronized during DML execution.

Parameter Format

Property	Description
Parameter type	String
Default Value	"SYNC"
Class	Optional, Static
Range

LOG_BACKUP_DIR

LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	""
Class	Mandatory, Static
Range

LOG_BACKUP_SIZE

LOG_BACKUP_SIZE specifies the maximum size of all backup files in the process. If this limit is exceeded, the oldest log files in the directory are deleted.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	0
Class	Optional, Dynamic
Range	0 - 128G

LOG_DIR

LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	""
Class	Mandatory, Static
Range

LOG_FILE_SIZE

LOG_FILE_SIZE specifies the maximum log file size. If a log file exceeds this limit, it is moved to the backup directory and a new log file is created.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	104857600
Class	Optional, Dynamic
Range	1M - 1G

LOG_LEVEL

LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	3
Class	Mandatory, Dynamic
Range	1 - 5

MAP

MAP specifies the mapping information of the target table for synchronization. For more information, refer to ProSync Administrator's Guide.

Parameter Format

Property	Description
Parameter type	desc
Default Value	"(TABLE DEFAULT)"
Class	Mandatory, Dynamic
Range

MAP_SKIP_UPD_WHERE

MAP_SKIP_UPD_WHERE specifies where clause or the set clause when check skipping update dml. If set 'Y', prosync skip using where clause and otherwise, prosync skip using set clause.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Static
Range

MEMORY_CTRL_RESUME_SIZE

Apply control threads resumes the receiving of msg from ext when total size of un-committed but fully constructed tx is smaller than this parameter.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	1073741824
Class	Optional, Static
Range	1 - UINT64_MAX & MEMORY_CTRL_RESUME_SIZE < MEMORY_CTRL_STOP_SIZE

MEMORY_CTRL_STOP_SIZE

Apply control thread stops receiving msg from ext when total size of un-committed but fully constructed tx is larger than this parameter.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	2147483648
Class	Optional, Static
Range	1 - UINT64_MAX & MEMORY_CTRL_RESUME_SIZE < MEMORY_CTRL_STOP_SIZE

MERGE_BLOCK_CNT

BLOCK EXT STMT COUNT

Parameter Format

Property	Description
Parameter type	Integer
Default Value	1000
Class	Optional, Static
Range	1 - UINT32_MAX & MERGE_RESUME_CNT < MERGE_BLOCK_CNT

MERGE_RESUME_CNT

RESUME EXT STMT COUNT

Parameter Format

Property	Description
Parameter type	Integer
Default Value	100
Class	Optional, Static
Range	1 - UINT32_MAX & MERGE_RESUME_CNT < MERGE_BLOCK_CNT

OCI_DRIVER

OCI_DRIVER specifies a path to the client library used to access a database. An absolute path must be specified. for Oracle, enter a path to the libclntsh.so file.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

ODBC_DRIVER

ODBC_DRIVER specifies a path to the client library used to access a database. An absolute path must be specified. Set a path to the proper library file.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

PRS_PROC_AGENT_CONNECTION_TIMEOUT

connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself

Parameter Format

Property	Description
Parameter type	Integer
Default Value	180
Class	Optional, Static
Range	0 - 86400

PRS_PWD

PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.

Parameter Format

Property	Description
Parameter type	String
Default Value	"#encrypted"
Class	Mandatory, Static
Range

PRS_USER

PRS_USER specifies the database user.

Parameter Format

Property	Description
Parameter type	String
Default Value	""
Class	Mandatory, Static
Range

PR_MODE

Parallel Replay object id mode

Parameter Format

Property	Description
Parameter type	String
Default Value	"OBJ"
Class	Optional, Static
Range

RECORD_HISTORY

records history when DML occurred.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	N
Class	Optional, Static
Range

REPLAY_THREAD_CNT

Number of replay thread cnt when starting prosync.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	4
Class	Optional, Static
Range	1 - 20

REPO_RESOURCE_INSERT_INTERVAL

This parameter decides how often to insert resource data into repoDB.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	60
Class	Optional, Static
Range	60 - 3600

SAM_BACKUP_DIR

SAM_BACKUP_DIR specifies the directory where the SAM files of ext process are backed up. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

SAM_BACKUP_SIZE

SAM_BACKUP_SIZE specifies the maximum size of SAM backup files of ext process. If this limit is exceeded, the oldest SAM files in the directory are deleted.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	0
Class	Optional, Dynamic
Range	0 - 128G

SAM_BIND_VALUE

SAM_BIND_VALUE

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Dynamic
Range	SAM_BIND_VALUE specifies whether to retain the values of the query in SAM files. If set to 'Y', the specific values of the query are retained. If set to 'N', every value in the query is replaced with '?'.

SAM_DIR

SAM_DIR specifies the directory where the sam files are stored. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

SAM_FILE_SIZE

SAM_FILE_SIZE specifies the maximum SAM file size of ext process. If a SAM file exceeds this limit, it is moved to the backup directory and a new SAM file is created.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	17179869184
Class	Optional, Dynamic
Range	1M - 16G

SAM_LOG_PREFIX

SAM_LOG_PREFIX specifies whether to include timestamp and thread information for each query in the SAM files, similar to how prosync logging works. If set to 'Y', this information is prepended to each row in the SAM files. If set to 'N', the timestamp and thread information is not included on each row.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Dynamic
Range

SQL_REDO_MODE

The SQL_REDO_MODE parameter specifies whether to log the full DML/DDL statements into the SAM files. Y: The DML statements are logged row-by-row into the SAM files. (This is the default setting). N: The DML statements are not logged row-by-row into the SAM files.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Static
Range

SRC_DB_CHARSET

SRC_DB_CHARSET specifies the character set of the source database.

Parameter Format

Property	Description
Parameter type	String
Default Value	"MSWIN949"
Class	Optional, Static
Range	"ASCII", "US7ASCII", "EUCKR", "KO16KSC5601", "MSWIN949","KO16MSWIN949", "UTF8", "AL32UTF8", "UTF16", "AL16UTF16", "SJIS", "JA16SJIS", "JA16SJISTILDE", "JA16EUC", "JA16EUCTILDE", "GBK", "ZHS16GBK", "VN8VN3", "WE8MSWIN1252", "ZHT16HKSCS", "CL8MSWIN1251", "WE8ISO8859P1", "EE8ISO8859P2", "WE8ISO8859P9", "WE8ISO8859P15", "CL8KOI8R", "CL8ISO8859P5", "RU8PC866", "TH8TISASCII", "EL8MSWIN1253", "EL8ISO8859P7", "AR8MSWIN1256", "AR8ISO8859P6"

SRC_DB_CNT

Parameter Format

Property	Description
Parameter type	Integer
Default Value	1
Class	Mandatory, Static
Range	1 - 32

SRC_DB_NCHARSET

SRC_DB_NCHARSET specifies the national character set of the source database.

Parameter Format

Property	Description
Parameter type	String
Default Value	"UTF16"
Class	Optional, Static
Range

STMT_SAM_TEMPLATE

The STMT_SAM_TEMPLATE parameter sets the path to the user-defined template file to be used when logging statement (DML/DDL) content to the SAM file. It works when SQL_REDO_MODE is set to N. ProSync reads the template from the specified path and logs the DDL and DML content to the SAM file according to that template format.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

TAR_DB_NAME

TAR_DB_NAME specifies the name(Alias) of the target database. For TIBERO, UPDB, or K-DB, use the value specified in the dsn file. For ORACLE, use the value specified in the tnsname file.

Parameter Format

Property	Description
Parameter type	String
Default Value	""
Class	Mandatory, Static
Range

TAR_DB_TYPE

TAR_DB_TYPE specifies the type of the target database to apply data to. Options are TIBERO, UPDB, KDB, or ORACLE.

Parameter Format

Property	Description
Parameter type	String
Default Value	"TIBERO"
Class	Mandatory, Static
Range

TDE_FOR_APPLY

TDE_FOR_APPLY specifiese whether use data decryption from source database

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	N
Class	Optional, Static
Range

TDE_WALLET_FILE

TDE_WALLET_FILE specifies the wallet file name of source db including absolute path

Parameter Format

Property	Description
Parameter type	String
Default Value	"/"
Class	Optional, Static
Range

TDE_WALLET_PWD

TDE_WALLET_PWD specifies the password of wallet file for tde

Parameter Format

Property	Description
Parameter type	String
Default Value	"#encrypted"
Class	Optional, Static
Range

TX_HASH_FILE_CNT

TX_HASH_FINE_CNT determines how many tx_hash_files to keep in PRS_TX_DIR

Parameter Format

Property	Description
Parameter type	Integer
Default Value	0
Class	Optional, Static
Range	0 - 32

TX_HASH_FILE_DIR

TX_HASH_FILE_DIR specifies the directory where the ProSync tx hashes are saved. It must be specified as an absolute path.

Parameter Format

Property	Description
Parameter type	path
Default Value	""
Class	Optional, Static
Range

TX_HASH_FILE_MODE

TX_HASH_FILE_MODE determines how to control tx_hash_files

Parameter Format

Property	Description
Parameter type	String
Default Value	"CNT"
Class	Optional, Static
Range

TX_HASH_FILE_TOTAL_SIZE

TX_HASH_FILE_TOTAL_SIZE determines max size of every tx_hash_files to keep in PRS_TX_DIR

Parameter Format

Property	Description
Parameter type	Integer
Default Value	0
Class	Optional, Static
Range	0 - 1000G

TX_HASH_SIZE

TX_HASH_SIZE specifies the maximum memory size that the apply process can use for transaction data. If this size is not sufficient, there will be frequent swapping between memory and disk which will affect performance.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	2147483648
Class	Optional, Dynamic
Range	1M - 32G

TX_SAM_TEMPLATE

The TX_SAM_TEMPLATE parameter sets the path to the user-defined template file to be used when outputting transactions to the SAM file. It works when SQL_REDO_MODE is set to N. ProSync reads the template from the specified path whenever a transaction encounters a commit, and logs the transaction content to the SAM file according to that template format.

Parameter Format

Property	Description
Parameter type	path
Default Value	"/"
Class	Optional, Static
Range

UPDATE_LCT_WHEN_ADD_HIST

UPDATE_LCT_WHEN_SWTICH_LOG determines whether to execute UPDATE_LCT or not when a replay thread inserts ADD_CONST_HIST information.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Static
Range

USE_BATCH_MODE

This parameter determines whether the replay thread use the array bind or not.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Static
Range

USE_LOGMNR

USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	N
Class	Optional, Static
Range

USE_ONLY_INSERT_BATCH

use batch mode for insert only

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	Y
Class	Optional, Static
Range

USE_PK_FOR_WHERE

USE_PK_FOR_WHERE specifiese whether use only PK columns when replay thread generate and bind the where clause of dml(update and delete) or not.

Parameter Format

Property	Description
Parameter type	Boolean
Default Value	N
Class	Optional, Static
Range

VERIFY_TIMEOUT

time interval to check whether child process is dead or not.

Parameter Format

Property	Description
Parameter type	Integer
Default Value	1800
Class	Optional, Static
Range	1 - 3600