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