> For the complete documentation index, see [llms.txt](https://docs.tibero.com/prosync/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tibero.com/prosync/appendix-parameters/apply-parameters.md). # 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\_DDL\_BACKUP\_DIR 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. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### DISCARD\_DDL\_BACKUP\_SIZE 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. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Integer | | Default Value | 0 | | Class | Optional, Dynamic | | Range | 0 - 128G | ### DISCARD\_DDL\_FILE\_DIR DISCARD\_DDL\_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\_DDL\_FILE\_SIZE 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. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Integer | | Default Value | 104857600 | | Class | Optional, Dynamic | | Range | 1M - 1G | ### DISCARD\_DDL\_FILE\_YN Y to make a file of error DDL that discarded during sync. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Dynamic | | Range | | ### DISCARD\_DDL\_YN Toggle Discard DDL feature. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### 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 | ### --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.tibero.com/prosync/appendix-parameters/apply-parameters.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.