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
Parameter type
path
Default Value
""
Class
Optional, Static
Range
CONN_MAX
CONN_MAX specifies the max number of connections between processes.
Parameter Format
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
Parameter type
path
Default Value
""
Class
Optional, Static
Range
DSN_FILE
DSN_FILE specifies name of dsn file.
Parameter Format
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
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
Parameter type
String
Default Value
"CURRENT"
Class
Mandatory, Static
Range
LLOB_THREAD_CNT
Number of llob thread cnt when starting prosync.
Parameter Format
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
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
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
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
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
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
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
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
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
Parameter type
String
Default Value
"#encrypted"
Class
Mandatory, Static
Range
PRS_USER
PRS_USER specifies the database user.
Parameter Format
Parameter type
String
Default Value
""
Class
Mandatory, Static
Range
SRC_DB_IP
SRC_DB_IP specifies the database IP Address.
Parameter Format
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
Parameter type
String
Default Value
""
Class
Mandatory, Static
Range
SRC_DB_PORT
SRC_DB_PORT specifies the database port.
Parameter Format
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
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
Parameter type
Boolean
Default Value
N
Class
Optional, Static
Range
Last updated