> 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/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          |                  |

###


---

# 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/llob-parameters.md?ask=<question>&goal=<endgoal>
```

`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.