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

Last updated