CONN_MAX specifies the max number of connections between processes.
Parameter type
Integer
Default Value
LISTENER_PORT specifies the port number used by each process. All processes on the same machine must use different ports.
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
cm probe timeout. when it's 0, indefinitely wait returns from cm. works only when USE_CM=Y
time interval to check whether child process is dead or not.
maximum fail count to calibrate process status internally. works only when USE_CM=Y
startup timeout seconds, [startup request to wthr - logon recv]. works only when USE_CM=Y
proc status check interval. works only when USE_CM=Y
read idle timeout seconds, for status reply. works only when USE_CM=Y
time interval to get statistic information. agent sends info req msg to ext and apply.
This parameter decides how often to insert resource data into repoDB.
USE_CM specifiese whether use cm management for failover or not.
128
Class
Optional, Static
Range
32 - 1024
Parameter type
Integer
Default Value
7600
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Integer
Default Value
5
Class
Parameter type
Integer
Default Value
10
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
10
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
1024 - 65535
Mandatory, Static
Range
Optional, Dynamic
Range
0 - 128G
Mandatory, Static
Range
Optional, Dynamic
Range
1M - 1G
Mandatory, Dynamic
Range
1 - 5
Optional, Static
Range
0 - PRS_AGENT_CM_PROBE_TIMEOUT < PRS_AGENT_PROC_STATUS_INTERVAL
Optional, Static
Range
1 - 3600
Optional, Static
Range
1 - 3600
Optional, Static
Range
5 - 256
Optional, Static
Range
2 - 256
Optional, Static
Range
6 - 256
Optional, Static
Range
1 - 3600
Optional, Static
Range
60 - 3600
Optional, Static
Range
An initialization parameter describes a ProSync configuration. It is provided with a text file and required to create a ProSync.
An initialization parameter file is a text file, with a filename in the form prosync.cfg needed when starting a ProSync. It can be edited using a document editor provided with the operating system. Once the initialization parameter file is modified, the ProSync must be restarted to apply the modification to the entire system.
However, not all initialization parameters require the restarting of the ProSync after their modification. Some parameters can be modified while being used by an instance. These parameters are applied only to the current instance, not the initialization parameter file.
This section explains the class attributes necessary for users to understand the information configured in the initialization parameter file.
Static/Dynamic
Static
A parameter that cannot be modified during system operation.
Dynamic
A parameter that can be modified during system operation.
Mandatory/Optional
Mandatory
A parameter required to start up a system. If these parameter are not defined in the initialization parameter file, the system cannot be booted.
Optional
A parameter that uses a default value if not defined in the initialization parameter.
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 type
path
Default Value
CONN_MAX specifies the max number of connections between processes.
DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.
DSN_FILE specifies name of dsn file.
LISTENER_PORT specifies the port number used by each process. All processes on the same machine must use different ports.
LLOB_FLASHBACK_ERROR specifies how to handle an error during a flashback query on a LONG/LOB column. If set to 'SKIP', the column is not synchronized; if set to 'CURRENT', the query is re-executed for the latest value.
Number of llob thread cnt when starting prosync.
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
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.
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.
connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself
PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.
PRS_USER specifies the database user.
SRC_DB_IP specifies the database IP Address.
SRC_DB_NAME specifies the name(Alias) of the source 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.
SRC_DB_PORT specifies the database port.
SRC_DB_TYPE specifies the type of the source database to extract data from. Options are TIBERO, UPDB, KDB, or ORACLE.
USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.
""
Class
Optional, Static
Range
Parameter type
Integer
Default Value
128
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
7600
Class
Parameter type
String
Default Value
"CURRENT"
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
180
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"localhost"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"7600"
Class
Parameter type
String
Default Value
"TIBERO"
Class
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
32 - 1024
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1024 - 65535
Mandatory, Static
Range
Optional, Static
Range
1 - 4
Mandatory, Static
Range
Optional, Dynamic
Range
0 - 128G
Mandatory, Static
Range
Optional, Dynamic
Range
1M - 1G
Mandatory, Dynamic
Range
1 - 5
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 86400
Mandatory, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Static
Range
ARCHIVE_LOG_DIR specifies the directory where the archive logs are stored. It must be specified as an absolute path.
Parameter type
path
Default Value
ARCHIVE_LOG_FORMAT specifies the archived log file format. Supported formats are %r:RESETLOGS_CHANGE#, %s:SEQUENCE#, %S:8byte SEQUENCE# padded with 0, and %t:THREAD#.
BINLOG_INIT_POSITION specifies the starting position of mysql binlog.
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.
CONNECT_TO_APPLY_CHECK_INTERVAL specifies the interval at which the connection is attempted when the connection between ext and apply is lost.
CONN_MAX specifies the max number of connections between processes.
DICT_FILE_DIR specifies the directory where user wants to make dictfile while using oracle logminer version.
DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.
DSN_FILE specifies name of dsn file.
DUMMY_LOG_SEND_INTERVAL_COMMIT_TSN specifies the interval of sending dummy tx to prevent synchronization delay in TAC and RAC.
DUMMY_TX_INTERVAL specifies instance status check interval (in seconds) in a cluster database environment. The extract process does not perform status checks at each interval. The check occurs at the set interval from the time when there are no more redo or archive logs to read (no new logs are generated).
ENABLE_NETWORK_COMPRESS specifies whether to compress data when sending data from the extract process to the apply process. If set to 'Y', performance may be affected due to the compress/decompress process when sending/receiving data. This is useful when sending large amounts of data across a large network.
ENABLE_NETWORK_ENCRYPT specifies whether to encrypt data when sending data from the extract process to the apply process. If set to 'Y', data is sent using the SSL protocol.
EXCLUDE_USER specifies the name of a user to be excluded from extract operations. If bi-directional synchronization is used, enter a ProSync user name that uses reverse directional synchronization.
EXTRACT_ARCHIVE_LOG_ONLY specifies to only extract archived log. If set to 'Y', redo log is archived and cannot be extracted until a new archived log is created.
EXTRACT_NUM specifies the instance number of the source database. It must be greater than or equal to 1. For a database cluster, each extract process must be assigned a different number in sequential order (1, 2, 3...).
This parameter sets whether to log statements that are passed from the EXT process to the APPLY process into the SAM file. (Y/N)
INSTANCE_FAILURE_CHECK_INTERVAL specifies instance status check interval (in seconds) in a cluster database environment. The extract process does not perform status checks at each interval. The check occurs at the set interval from the time when there are no more redo or archive logs to read (no new logs are generated).
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
LOG_SWITCH_INTERVAL specifies interval of log switch.
LR_LOG_BACKUP_DIR specifies the directory where the LR_LOG files of ext process are backed up. It must be specified as an absolute path.
LR_LOG_BACKUP_SIZE specifies the maximum size of LR_LOG backup files of ext process. If this limit is exceeded, the oldest LR_LOG files in the directory are deleted.
LR_LOG_DIR specifies the directory where the LR_LOG files are stored. It must be specified as an absolute path.
LR_LOG_FILE_SIZE specifies the maximum LR_LOG file size of ext process. If a LR_LOG file exceeds this limit, it is moved to the backup directory and a new LR_LOG file is created.
LR_STOP_AT_CORRUPTED_LCR_0 determines whether to stop when extracting a corrupted LCR for a table with object id and segment id equal to 0
LR_STOP_AT_CORRUPTED_LCR_ALL determines whether to stop when extracting all types of corrupted LCR
LR_STOP_AT_CORRUPTED_LCR_TARGET determines whether to stop when a corrupted LCR is extracted for the synchronization table
LR_TRACE_LVL specifies the logging level of the log reader. A higher log-level produces more detailed logs.
LR_WARN_AT_CORRUPTED_LCR_0 determines whether the log type of a corrupted LCR with object id and segment id equal to 0 will be [W] or [F]
LR_WARN_AT_CORRUPTED_LCR_ALL determines whether the log type for all types of corrupted LCR will be [W] or [F]
LR_WARN_AT_CORRUPTED_LCR_TARGET determines whether the log type of a corrupted LCR for the synchronization table will be [W] or [F]
MYSQL_BINLOG_PREFIX specifies the prefix of mysql binlog file name.
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.
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.
PQ_DRIVER specifies a path to the pq library used to access a database. An absolute path must be specified. For Tibero, set a path to the libpq.so file.
PQ_REP_CONN_NAME specifies the repliucation connection name.
PREFETCH_SIZE specifies the number of rows to fetch for each oci fetch call. This parameter is used only in oracle logminer version.
connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself
PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.
PRS_USER specifies the database user.
This parameter decides how often to insert resource data into repoDB.
If a transaction references any object ID listed in this parameter, skip the entire transaction.
SAM_BACKUP_DIR specifies the directory where the SAM files of ext process are backed up. It must be specified as an absolute path.
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.
SAM_BIND_VALUE
SAM_DIR specifies the directory where the sam files are stored. It must be specified as an absolute path.
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.
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.
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.
SRC_DB_IP specifies the database IP Address.
SRC_DB_NAME specifies the name(Alias) of the source 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.
SRC_DB_PORT specifies the database port.
SRC_DB_TYPE specifies the type of the source database to extract data from. Options are TIBERO, UPDB, KDB, or ORACLE.
SRC_LOCAL_SID indicates specified instance name of the source database in RAC or TAC.
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.
TDE_FOR_EXT specifiese whether use data decryption from source database
TDE_FOR_TABLESPACE specifiese whether use tablespace decryption from source database
Absolute library path with the library file name. It is used for linking with an HSM device.
pin value for HSM. It is used for linking with an HSM device.
Option to use the PKCS #11 wrapping key option for linking an HSM device.
Option to use Hardware Security Module (HSM) to save data encryption keys.
TDE_WALLET_FILE specifies the wallet file name of source db including absolute path
TDE_WALLET_PWD specifies the password of wallet file for tde
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.
USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.
""
Class
Mandatory, Static
Range
Parameter type
String
Default Value
"log-t%t-r%r-s%s.arc"
Class
Parameter type
Integer
Default Value
120
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
128
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
1000
Class
Parameter type
Integer
Default Value
5
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
""
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
5
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
17179869184
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
2
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
String
Default Value
"bin"
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Integer
Default Value
180
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
desc
Default Value
"()"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
17179869184
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
String
Default Value
"localhost"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"7600"
Class
Parameter type
String
Default Value
"TIBERO"
Class
Parameter type
String
Default Value
""
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
"/"
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
desc
Default Value
"(FILTER DEFAULT)"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Boolean
Default Value
N
Class
Mandatory, Static
Range
Optional, Static
Range
1 - INT32_MAX
Optional, Static
Range
Optional, Static
Range
0 - 3600
Optional, Static
Range
32 - 1024
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
10 - UINT64_MAX
Optional, Static
Range
1 - 1000
Optional, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Mandatory, Static
Range
1 - 1024
Optional, Static
Range
Optional, Dynamic
Range
Optional, Static
Range
5 - 3600
Mandatory, Static
Range
Optional, Dynamic
Range
0 - 128G
Mandatory, Static
Range
Optional, Dynamic
Range
1M - 1G
Mandatory, Dynamic
Range
1 - 5
Optional, Static
Range
0 - INT32_MAX
Optional, Static
Range
Optional, Static
Range
0 - 128G
Optional, Static
Range
Optional, Static
Range
1M - 16G
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
1 - 5
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 10000
Optional, Static
Range
1 - 120
Optional, Static
Range
Optional, Static
Range
0 - 9
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1 - UINT32_MAX
Optional, Static
Range
0 - 86400
Mandatory, Static
Range
Mandatory, Static
Range
Optional, Static
Range
60 - 3600
Optional, Static
Range
1 - 120
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
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 '?'.
Optional, Static
Range
Optional, Dynamic
Range
1M - 16G
Optional, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Number of retries to apply dml before leaving a log to report file.
Parameter type
Integer
Default Value
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...).
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.
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.
APPLY_REPORT_DIR specifies the directory where the report files are stored. It must be specified as an absolute path.
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.
Determines whether to leave a log on the report file or not.
This parameter sets whether to log the statements that the APPLY process applies to the database into the SAM file. (Y/N)
This parameter determines the maximum value of LCR data to be stored for array bind.
Apply control thread stops receiving msg from ext when total chunk size of un-constructed exceeded.
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.
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.
CONN_MAX specifies the max number of connections between processes.
DDL specifies DDL filtering options. For more information, refer to ProSync DDL RULE in Administrator's Guide.
DISCARD_BACKUP_DIR specifies the directory where the discard files of ext process are backed up. It must be specified as an absolute path.
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.
DISCARD_DDL_BACKUP_DIR specifies the directory where the discard files of ext process are backed up. It must be specified as an absolute path.
DISCARD_DDL_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.
DISCARD_DDL_FILE_DIR specifies the directory where the discard files are stored. It must be specified as an absolute path.
DISCARD_DDL_FILE_SIZE specifies the maximum discard file size of apply process. If a discard file exceeds this limit, it is moved to the backup directory and a new discard file is created.
Y to make a file of error DDL that discarded during sync.
Toggle Discard DDL feature.
List error codes to ignore during sync. (max 256 codes)
DISCARD_FILE_DIR specifies the directory where the discard files are stored. It must be specified as an absolute path.
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.
Y to make a file of error codes that discarded during sync.
Toggle Discard feature.
This parameter determines retry interval when DML fails
DSN_DIR specifies the directory where the dsn file located. It must be specified as an absolute path.
DSN_FILE specifies name of dsn file.
GROUP_NUM specifies the number of replay groups in multi-grouping mode.
The number of retries in a fault situation absence of primary key. Default value means infinite retries.
This parameter decides how often to update the target meta tables PRS_COMMITTED_TX_LIST and PRS_LCT. The unit is in seconds.
a leading prosync user in history topology
LISTENER_PORT specifies the port number used by each process. All processes on the same machine must use different ports.
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.
LOG_BACKUP_DIR specifies the directory where the ProSync log files are backed up. It must be specified as an absolute path.
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.
LOG_DIR specifies the directory where the ProSync log files are stored. It must be specified as an absolute path.
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.
LOG_LEVEL specifies the log level of the process. A higher log-level produces more detailed logs.
MAP specifies the mapping information of the target table for synchronization. For more information, refer to ProSync Administrator's Guide.
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.
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.
Apply control thread stops receiving msg from ext when total size of un-committed but fully constructed tx is larger than this parameter.
BLOCK EXT STMT COUNT
RESUME EXT STMT COUNT
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.
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.
connection timeout from process to agent. if a process cannot connect to agent while this timeout, kill itself
PRS_PWD specifies the database user password. If the password is encrypted, append the string '#encrypted'.
PRS_USER specifies the database user.
Parallel Replay object id mode
records history when DML occurred.
Number of replay thread cnt when starting prosync.
This parameter decides how often to insert resource data into repoDB.
SAM_BACKUP_DIR specifies the directory where the SAM files of ext process are backed up. It must be specified as an absolute path.
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.
SAM_BIND_VALUE
SAM_DIR specifies the directory where the sam files are stored. It must be specified as an absolute path.
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.
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.
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.
SRC_DB_CHARSET specifies the character set of the source database.
SRC_DB_NCHARSET specifies the national character set of the source database.
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.
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.
TAR_DB_TYPE specifies the type of the target database to apply data to. Options are TIBERO, UPDB, KDB, or ORACLE.
TDE_FOR_APPLY specifiese whether use data decryption from source database
TDE_WALLET_FILE specifies the wallet file name of source db including absolute path
TDE_WALLET_PWD specifies the password of wallet file for tde
TX_HASH_FINE_CNT determines how many tx_hash_files to keep in PRS_TX_DIR
TX_HASH_FILE_DIR specifies the directory where the ProSync tx hashes are saved. It must be specified as an absolute path.
TX_HASH_FILE_MODE determines how to control tx_hash_files
TX_HASH_FILE_TOTAL_SIZE determines max size of every tx_hash_files to keep in PRS_TX_DIR
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.
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.
UPDATE_LCT_WHEN_SWTICH_LOG determines whether to execute UPDATE_LCT or not when a replay thread inserts ADD_CONST_HIST information.
This parameter determines whether the replay thread use the array bind or not.
USE_LOGMNR specifies whether to use oracle logminer or to use oracle log reader, when analyzing redo logs.
use batch mode for insert only
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.
time interval to check whether child process is dead or not.
20
Class
Optional, Static
Range
0 - 100000
Parameter type
Integer
Default Value
1
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
10485760
Class
Parameter type
Integer
Default Value
1073741824
Class
Parameter type
path
Default Value
""
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
128
Class
Parameter type
desc
Default Value
"(INCLUDE DEFAULT, TYPE=('ALTER TABLE','TRUNCATE TABLE'))"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
desc
Default Value
"()"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
String
Default Value
""
Class
Parameter type
Integer
Default Value
7600
Class
Parameter type
String
Default Value
"SYNC"
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
Integer
Default Value
104857600
Class
Parameter type
Integer
Default Value
3
Class
Parameter type
desc
Default Value
"(TABLE DEFAULT)"
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Integer
Default Value
1073741824
Class
Parameter type
Integer
Default Value
2147483648
Class
Parameter type
Integer
Default Value
1000
Class
Parameter type
Integer
Default Value
100
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
180
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"OBJ"
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
4
Class
Parameter type
Integer
Default Value
60
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Integer
Default Value
17179869184
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
String
Default Value
"MSWIN949"
Class
Parameter type
Integer
Default Value
1
Class
Parameter type
String
Default Value
"UTF16"
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
String
Default Value
""
Class
Parameter type
String
Default Value
"TIBERO"
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
String
Default Value
"/"
Class
Parameter type
String
Default Value
"#encrypted"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
path
Default Value
""
Class
Parameter type
String
Default Value
"CNT"
Class
Parameter type
Integer
Default Value
0
Class
Parameter type
Integer
Default Value
2147483648
Class
Parameter type
path
Default Value
"/"
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Boolean
Default Value
Y
Class
Parameter type
Boolean
Default Value
N
Class
Parameter type
Integer
Default Value
1800
Class
Mandatory, Static
Range
1 - 1024
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
Optional, Static
Range
Optional, Dynamic
Range
1M - 1G
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
Optional, Static
Range
1024 - UINT64_MAX
Optional, Static
Range
1 - UINT64_MAX
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
32 - 1024
Mandatory, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
Optional, Static
Range
Optional, Dynamic
Range
1M - 1G
Optional, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Dynamic
Range
1M - 1G
Optional, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
1 - 1048576
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1 - 20
Optional, Static
Range
0 - UINT16_MAX
Optional, Static
Range
1 - INT32_MAX
Optional, Static
Range
Optional, Static
Range
1024 - 65535
Optional, Static
Range
Mandatory, Static
Range
Optional, Dynamic
Range
0 - 128G
Mandatory, Static
Range
Optional, Dynamic
Range
1M - 1G
Mandatory, Dynamic
Range
1 - 5
Mandatory, Dynamic
Range
Optional, Static
Range
Optional, Static
Range
1 - UINT64_MAX & MEMORY_CTRL_RESUME_SIZE < MEMORY_CTRL_STOP_SIZE
Optional, Static
Range
1 - UINT64_MAX & MEMORY_CTRL_RESUME_SIZE < MEMORY_CTRL_STOP_SIZE
Optional, Static
Range
1 - UINT32_MAX & MERGE_RESUME_CNT < MERGE_BLOCK_CNT
Optional, Static
Range
1 - UINT32_MAX & MERGE_RESUME_CNT < MERGE_BLOCK_CNT
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 86400
Mandatory, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1 - 20
Optional, Static
Range
60 - 3600
Optional, Static
Range
Optional, Dynamic
Range
0 - 128G
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 '?'.
Optional, Static
Range
Optional, Dynamic
Range
1M - 16G
Optional, Dynamic
Range
Optional, Static
Range
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"
Mandatory, Static
Range
1 - 32
Optional, Static
Range
Optional, Static
Range
Mandatory, Static
Range
Mandatory, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 32
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
0 - 1000G
Optional, Dynamic
Range
1M - 32G
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
Optional, Static
Range
1 - 3600