> 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/extract-parameters.md). # Extract Parameters ### ARCHIVE\_LOG\_DIR ARCHIVE\_LOG\_DIR specifies the directory where the archive logs are stored. It must be specified as an absolute path. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | path | | Default Value | "" | | Class | Mandatory, Static | | Range | | ### ARCHIVE\_LOG\_FORMAT ARCHIVE\_LOG\_FORMAT specifies the archived log file format. Supported formats are %r:RESETLOGS\_CHANGE#, %s:SEQUENCE#, %S:8byte SEQUENCE# padded with 0, and %t:THREAD#. #### Parameter Format | Property | Description | | -------------- | --------------------- | | Parameter type | String | | Default Value | "log-t%t-r%r-s%s.arc" | | Class | Mandatory, Static | | Range | | ### BINLOG\_INIT\_POSITION BINLOG\_INIT\_POSITION specifies the starting position of mysql binlog. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 120 | | Class | Optional, Static | | Range | 1 - INT32\_MAX | ### COL\_SAM\_TEMPLATE The COL\_SAM\_TEMPLATE parameter sets the path to the user-defined template file to be used when outputting column content for DML statements. It works when SQL\_REDO\_MODE is set to N. When logging DML statements, if column definitions are present in the COL\_SAM\_TEMPLATE, ProSync logs the column information to the SAM file according to that template format. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### CONNECT\_TO\_APPLY\_CHECK\_INTERVAL CONNECT\_TO\_APPLY\_CHECK\_INTERVAL specifies the interval at which the connection is attempted when the connection between ext and apply is lost. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 0 | | Class | Optional, Static | | Range | 0 - 3600 | ### 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 | ### DICT\_FILE\_DIR DICT\_FILE\_DIR specifies the directory where user wants to make dictfile while using oracle logminer version. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### 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 | | ### DUMMY\_LOG\_SEND\_INTERVAL\_COMMIT\_TSN DUMMY\_LOG\_SEND\_INTERVAL\_COMMIT\_TSN specifies the interval of sending dummy tx to prevent synchronization delay in TAC and RAC. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 1000 | | Class | Optional, Static | | Range | 10 - UINT64\_MAX | ### DUMMY\_TX\_INTERVAL DUMMY\_TX\_INTERVAL specifies instance status check interval (in seconds) in a cluster database environment. The extract process does not perform status checks at each interval. The check occurs at the set interval from the time when there are no more redo or archive logs to read (no new logs are generated). #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 5 | | Class | Optional, Static | | Range | 1 - 1000 | ### ENABLE\_NETWORK\_COMPRESS ENABLE\_NETWORK\_COMPRESS specifies whether to compress data when sending data from the extract process to the apply process. If set to 'Y', performance may be affected due to the compress/decompress process when sending/receiving data. This is useful when sending large amounts of data across a large network. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Dynamic | | Range | | ### ENABLE\_NETWORK\_ENCRYPT ENABLE\_NETWORK\_ENCRYPT specifies whether to encrypt data when sending data from the extract process to the apply process. If set to 'Y', data is sent using the SSL protocol. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### EXCLUDE\_USER EXCLUDE\_USER specifies the name of a user to be excluded from extract operations. If bi-directional synchronization is used, enter a ProSync user name that uses reverse directional synchronization. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "" | | Class | Optional, Static | | Range | | ### EXTRACT\_ARCHIVE\_LOG\_ONLY EXTRACT\_ARCHIVE\_LOG\_ONLY specifies to only extract archived log. If set to 'Y', redo log is archived and cannot be extracted until a new archived log is created. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### EXTRACT\_NUM EXTRACT\_NUM specifies the instance number of the source database. It must be greater than or equal to 1. For a database cluster, each extract process must be assigned a different number in sequential order (1, 2, 3...). #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Integer | | Default Value | 1 | | Class | Mandatory, Static | | Range | 1 - 1024 | ### EXT\_TO\_APPLY #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | Y | | Class | Optional, Static | | Range | | ### EXT\_TO\_SAM This parameter sets whether to log statements that are passed from the EXT process to the APPLY process into the SAM file. (Y/N) #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Dynamic | | Range | | ### INSTANCE\_FAILURE\_CHECK\_INTERVAL INSTANCE\_FAILURE\_CHECK\_INTERVAL specifies instance status check interval (in seconds) in a cluster database environment. The extract process does not perform status checks at each interval. The check occurs at the set interval from the time when there are no more redo or archive logs to read (no new logs are generated). #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 5 | | Class | Optional, Static | | Range | 5 - 3600 | ### 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 | ### LOG\_SWITCH\_INTERVAL LOG\_SWITCH\_INTERVAL specifies interval of log switch. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 0 | | Class | Optional, Static | | Range | 0 - INT32\_MAX | ### LR\_LOG\_BACKUP\_DIR LR\_LOG\_BACKUP\_DIR specifies the directory where the LR\_LOG files of ext process are backed up. It must be specified as an absolute path. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### LR\_LOG\_BACKUP\_SIZE LR\_LOG\_BACKUP\_SIZE specifies the maximum size of LR\_LOG backup files of ext process. If this limit is exceeded, the oldest LR\_LOG files in the directory are deleted. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 0 | | Class | Optional, Static | | Range | 0 - 128G | ### LR\_LOG\_DIR LR\_LOG\_DIR specifies the directory where the LR\_LOG files are stored. It must be specified as an absolute path. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### LR\_LOG\_FILE\_SIZE LR\_LOG\_FILE\_SIZE specifies the maximum LR\_LOG file size of ext process. If a LR\_LOG file exceeds this limit, it is moved to the backup directory and a new LR\_LOG file is created. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 17179869184 | | Class | Optional, Static | | Range | 1M - 16G | ### LR\_STOP\_AT\_CORRUPTED\_LCR\_0 LR\_STOP\_AT\_CORRUPTED\_LCR\_0 determines whether to stop when extracting a corrupted LCR for a table with object id and segment id equal to 0 #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### LR\_STOP\_AT\_CORRUPTED\_LCR\_ALL LR\_STOP\_AT\_CORRUPTED\_LCR\_ALL determines whether to stop when extracting all types of corrupted LCR #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### LR\_STOP\_AT\_CORRUPTED\_LCR\_TARGET LR\_STOP\_AT\_CORRUPTED\_LCR\_TARGET determines whether to stop when a corrupted LCR is extracted for the synchronization table #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### LR\_TRACE\_LVL LR\_TRACE\_LVL specifies the logging level of the log reader. A higher log-level produces more detailed logs. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Integer | | Default Value | 2 | | Class | Optional, Dynamic | | Range | 1 - 5 | ### LR\_WARN\_AT\_CORRUPTED\_LCR\_0 LR\_WARN\_AT\_CORRUPTED\_LCR\_0 determines whether the log type of a corrupted LCR with object id and segment id equal to 0 will be \[W] or \[F] #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | Y | | Class | Optional, Static | | Range | | ### LR\_WARN\_AT\_CORRUPTED\_LCR\_ALL LR\_WARN\_AT\_CORRUPTED\_LCR\_ALL determines whether the log type for all types of corrupted LCR will be \[W] or \[F] #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | Y | | Class | Optional, Static | | Range | | ### LR\_WARN\_AT\_CORRUPTED\_LCR\_TARGET LR\_WARN\_AT\_CORRUPTED\_LCR\_TARGET determines whether the log type of a corrupted LCR for the synchronization table will be \[W] or \[F] #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### MYSQLBINLOG\_RETRY\_CNT #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 3 | | Class | Optional, Static | | Range | 0 - 10000 | ### MYSQLBINLOG\_RETRY\_INTERVAL #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 3 | | Class | Optional, Static | | Range | 1 - 120 | ### MYSQL\_BINLOG\_PREFIX MYSQL\_BINLOG\_PREFIX specifies the prefix of mysql binlog file name. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "bin" | | Class | Optional, Static | | Range | | ### NETWORK\_COMPRESS\_LEVEL #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 1 | | Class | Optional, Static | | Range | 0 - 9 | ### 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 | | ### PQ\_DRIVER PQ\_DRIVER specifies a path to the pq library used to access a database. An absolute path must be specified. For Tibero, set a path to the libpq.so file. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "" | | Class | Optional, Static | | Range | | ### PQ\_REP\_CONN\_NAME PQ\_REP\_CONN\_NAME specifies the repliucation connection name. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "" | | Class | Optional, Static | | Range | | ### PREFETCH\_SIZE PREFETCH\_SIZE specifies the number of rows to fetch for each oci fetch call. This parameter is used only in oracle logminer version. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 1 | | Class | Optional, Static | | Range | 1 - UINT32\_MAX | ### 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 | | ### REPO\_RESOURCE\_INSERT\_INTERVAL This parameter decides how often to insert resource data into repoDB. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 60 | | Class | Optional, Static | | Range | 60 - 3600 | ### RESUME\_WAIT\_TIME #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Integer | | Default Value | 3 | | Class | Optional, Static | | Range | 1 - 120 | ### ROLLBACK\_OBJECT\_IDS If a transaction references any object ID listed in this parameter, skip the entire transaction. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | desc | | Default Value | "()" | | Class | Optional, Static | | Range | | ### SAM\_BACKUP\_DIR SAM\_BACKUP\_DIR specifies the directory where the SAM files of ext process are backed up. It must be specified as an absolute path. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### SAM\_BACKUP\_SIZE SAM\_BACKUP\_SIZE specifies the maximum size of SAM backup files of ext process. If this limit is exceeded, the oldest SAM files in the directory are deleted. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Integer | | Default Value | 0 | | Class | Optional, Dynamic | | Range | 0 - 128G | ### SAM\_BIND\_VALUE SAM\_BIND\_VALUE #### Parameter Format | Property | Description | | -------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | Parameter type | Boolean | | Default Value | Y | | Class | Optional, Dynamic | | Range | SAM\_BIND\_VALUE specifies whether to retain the values of the query in SAM files. If set to 'Y', the specific values of the query are retained. If set to 'N', every value in the query is replaced with '?'. | ### SAM\_DIR SAM\_DIR specifies the directory where the sam files are stored. It must be specified as an absolute path. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### SAM\_FILE\_SIZE SAM\_FILE\_SIZE specifies the maximum SAM file size of ext process. If a SAM file exceeds this limit, it is moved to the backup directory and a new SAM file is created. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Integer | | Default Value | 17179869184 | | Class | Optional, Dynamic | | Range | 1M - 16G | ### SAM\_LOG\_PREFIX SAM\_LOG\_PREFIX specifies whether to include timestamp and thread information for each query in the SAM files, similar to how prosync logging works. If set to 'Y', this information is prepended to each row in the SAM files. If set to 'N', the timestamp and thread information is not included on each row. #### Parameter Format | Property | Description | | -------------- | ----------------- | | Parameter type | Boolean | | Default Value | Y | | Class | Optional, Dynamic | | Range | | ### SQL\_REDO\_MODE The SQL\_REDO\_MODE parameter specifies whether to log the full DML/DDL statements into the SAM files. Y: The DML statements are logged row-by-row into the SAM files. (This is the default setting). N: The DML statements are not logged row-by-row into the SAM files. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | Y | | Class | Optional, 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 | | ### SRC\_LOCAL\_SID SRC\_LOCAL\_SID indicates specified instance name of the source database in RAC or TAC. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "" | | Class | Optional, Static | | Range | | ### STMT\_SAM\_TEMPLATE The STMT\_SAM\_TEMPLATE parameter sets the path to the user-defined template file to be used when logging statement (DML/DDL) content to the SAM file. It works when SQL\_REDO\_MODE is set to N. ProSync reads the template from the specified path and logs the DDL and DML content to the SAM file according to that template format. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, Static | | Range | | ### TDE\_FOR\_EXT TDE\_FOR\_EXT specifiese whether use data decryption from source database #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### TDE\_FOR\_TABLESPACE TDE\_FOR\_TABLESPACE specifiese whether use tablespace decryption from source database #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### TDE\_HSM\_LIB\_FILE Absolute library path with the library file name. It is used for linking with an HSM device. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "" | | Class | Optional, Static | | Range | | ### TDE\_HSM\_PIN pin value for HSM. It is used for linking with an HSM device. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "" | | Class | Optional, Static | | Range | | ### TDE\_HSM\_USE\_WRAPPING Option to use the PKCS #11 wrapping key option for linking an HSM device. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | Y | | Class | Optional, Static | | Range | | ### TDE\_USE\_HSM Option to use Hardware Security Module (HSM) to save data encryption keys. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | Boolean | | Default Value | N | | Class | Optional, Static | | Range | | ### TDE\_WALLET\_FILE TDE\_WALLET\_FILE specifies the wallet file name of source db including absolute path #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "/" | | Class | Optional, Static | | Range | | ### TDE\_WALLET\_PWD TDE\_WALLET\_PWD specifies the password of wallet file for tde #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | String | | Default Value | "#encrypted" | | Class | Optional, Static | | Range | | ### TX\_FILTER\_KEY #### Parameter Format | Property | Description | | -------------- | ------------------ | | Parameter type | desc | | Default Value | "(FILTER DEFAULT)" | | Class | Optional, Static | | Range | | ### TX\_SAM\_TEMPLATE The TX\_SAM\_TEMPLATE parameter sets the path to the user-defined template file to be used when outputting transactions to the SAM file. It works when SQL\_REDO\_MODE is set to N. ProSync reads the template from the specified path whenever a transaction encounters a commit, and logs the transaction content to the SAM file according to that template format. #### Parameter Format | Property | Description | | -------------- | ---------------- | | Parameter type | path | | Default Value | "/" | | Class | Optional, 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/extract-parameters.md?ask=&goal= ``` `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.