> 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/4.5_manual/appendix-parameters/llob-parameters.md). # LLOB Parameters ### 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 | | ### 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 | ### 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 | | ### 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\_FLASHBACK\_ERROR 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. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | String | | Default Value | "CURRENT" | | Class | Mandatory, Static | | Range | | ### LLOB\_THREAD\_CNT Number of llob thread cnt when starting prosync. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 1 | | Class | Optional, Static | | Range | 1 - 4 | ### 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 | ### 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 | | ### SRC\_DB\_IP SRC\_DB\_IP specifies the database IP Address. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "localhost" | | Class | Optional, Static | | Range | | ### SRC\_DB\_NAME 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. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | String | | Default Value | "" | | Class | Mandatory, Static | | Range | | ### SRC\_DB\_PORT SRC\_DB\_PORT specifies the database port. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "7600" | | Class | Optional, Static | | Range | | ### SRC\_DB\_TYPE SRC\_DB\_TYPE specifies the type of the source database to extract data from. Options are TIBERO, UPDB, KDB, or ORACLE. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | String | | Default Value | "TIBERO" | | Class | Mandatory, 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 | |