Apply Parameters
APPLY_DML_ERR_REPORT_CNT
Number of retries to apply dml before leaving a log to report file.
Parameter Format
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
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
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
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
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
Parameter type
Integer
Default Value
104857600
Class
Optional, Dynamic
Range
1M - 1G
APPLY_TO_DB
Parameter Format
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
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
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
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
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
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
Parameter type
path
Default Value
"/"
Class
Optional, Static
Range
CONN_MAX
CONN_MAX specifies the max number of connections between processes.
Parameter Format
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
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
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
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
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
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
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
Parameter type
Boolean
Default Value
N
Class
Optional, Dynamic
Range
DISCARD_YN
Toggle Discard feature.
Parameter Format
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
DML_WAIT_TIMEOUT
This parameter determines retry interval when DML fails
Parameter Format
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
Parameter type
path
Default Value
""
Class
Optional, Static
Range
DSN_FILE
DSN_FILE specifies name of dsn file.
Parameter Format
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Parameter type
String
Default Value
"#encrypted"
Class
Mandatory, Static
Range
PRS_USER
PRS_USER specifies the database user.
Parameter Format
Parameter type
String
Default Value
""
Class
Mandatory, Static
Range
PR_MODE
Parallel Replay object id mode
Parameter Format
Parameter type
String
Default Value
"OBJ"
Class
Optional, Static
Range
RECORD_HISTORY
records history when DML occurred.
Parameter Format
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
REPLAY_THREAD_CNT
Number of replay thread cnt when starting prosync.
Parameter Format
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
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
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
Parameter type
Integer
Default Value
0
Class
Optional, Dynamic
Range
0 - 128G
SAM_BIND_VALUE
SAM_BIND_VALUE
Parameter Format
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
USE_ONLY_INSERT_BATCH
use batch mode for insert only
Parameter Format
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
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
Parameter type
Integer
Default Value
1800
Class
Optional, Static
Range
1 - 3600
Last updated