Configuration parameters record the user-configurable settings.
The current values of all the global configuration parameters are stored in the Data Assurance System Database (DASD). To view, set, or change the current value of a configuration parameter, use the config command.
Parameter |
Description |
|---|---|
| agent_client_ctx_timeout_secs | Specifies the connection timeout, in seconds, between the DA server and the DA agent. Default: 5 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| agent_access_timeout_mins | Specifies the length of time the connection between the DA server and the DA agent remains open, even when there is no activity between them. Default: 60 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| agent_max_queue | Specifies the maximum number of rows the agent buffers in its output queue. The DA server reads the rows from the queue. The agent temporarily stops reading rows from the database table when the queue is full. Default: 1000 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| agent_max_request_queue | Specifies the maximum queue size for server requests for retry comparison and reconciliation. Default: 100 Min: 1 Max: 2147483647 This parameter requires a restart of DA server to take effect. |
| auto_recon_stmt_batch_size | Specifies the maximum number of SQL statements the DA server sends to the DA agent in a single invocation. Default: 100 Min: 1 Max: 10000 This parameter does not require a restart of DA server to take effect. |
| comparer_max_concurrent_threads | Specifies the maximum number of comparison threads used for concurrent comparisons. Default: 5 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| comparer_retry_delay_threshold_secs | Specifies the threshold value, in seconds, a DA server comparison can hold on to a comparison thread before attempting a retry. If the value is higher than retry_delay_sec, the DA server comparison holds on to the current comparison thread while waiting to retry. This may delay another comparison thread that is in the queue from starting. If the value is less than or equal to retry_delay_sec, the DA server comparison releases the current comparison thread and starts processing the next comparison in the queue. Default: 20 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| comparer_recently_finished_ttl_secs | Specifies the maximum time, in seconds, for job information to remain in the monitor job view. Default: 300 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| comparer_retry_max_keys_per_clause | The maximum number of single keys in a WHERE clause. Default: 10 Min: 1 Max: 100 This parameter does not require a restart of DA server to take effect. |
| comparer_retry_min_keys_in_range | Specifies the minimum number of keys used when calculating the selection criteria for keys as a range rather than as individuals. Default: 5 Min: 2 Max: 100 This parameter does not require a restart of DA server to take effect. |
| comparer_retry_min_fill_percent | Specifies the minimum fill percentage required when combining “single” keys into a range. When selecting a result set of adjacent or near-adjacent row keys, it is usually faster to select keys in a range rather than specifying each key separately in your statement. For example, to select every alternate rows between 1 to 100, use:
"select ... where id in(1,3,5,7..97,99)" Alternatively, you can fetch all rows in a range:
"select ... where id >=1 and id <= 100" Fetching all rows in a range is typically faster than running one or more in(...) statements. The above example has a fill percentage of 50, because only half of the selected rows are required. DA server skips all the extra rows. Default: 10 Min: 1 Max: 100 This parameter does not require a restart of DA server to take effect. |
| comparer_retry_min_fill_percent_literal | Specifies the minimum fill percentage required when combining “single” keys into a range for literal comparison. Default: 90 Min: 1 Max: 100 Note: Typically, you should set comparer_retry_min_fill_percent_literal to a higher value than comparer_retry_min_fill_percent because the cost of transmitting extra literal row data soon outweighs the performance benefit of range selection.
This parameter does not require a restart of DA server to take effect. |
| db_connection_retry_times | Specifies the maximum number of retries by the connection manager to connect to a database if the initial attempt fails. Default: 2 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| db_connection_retry_interval | Specifies the maximum wait time for the connection manager between successive database connection attempts. Default: 3 Min: 1 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| default_column_compare_mode | Specifies the default compare mode for columns. Default: column_hash Valid values: literal, column_hash, row_hash This parameter does not require a restart of DA server to take effect. |
| db_hash_ase_algorithm | Specifies the hash algorithm for the Adaptive Server database. Default: MD5 Valid Values: MD5 or SHA This parameter does not require a restart of DA server to take effect. |
| db_hash_ase_ignore_null | Specifies whether to ignore the issue of the Adaptive Server hashbytes limitation when calculating multihash values for the Adaptive Server database. Default: true Valid values: true or false This parameter does not require a restart of DA server to take effect. |
| db_hash_ase_using_option | Specifies the byte order option in the hash algorithm for the Adaptive Server database. Default: UNICODE_LSB Valid values: LSB, MSB, UNICODE, UNICODE_LSB, UNICODE_MSB This parameter does not require a restart of DA server to take effect. |
| enable_report_generator | Specifies whether or not to generate job reports. When you set enable_report_generator to false, it prevents the report generator from creating XML and text reports when a job history item is viewed and the reports have not yet been generated. This may be useful if the column log is very large, and the reports may take a long time to generate. Default: true Valid values: true or false This parameter does not require a restart of DA server to take effect. |
| external_sort_max_thread | Specifies the maximum number of threads used for external sort. Default: 5 Min: 3 Max: 10 This parameter does not require a restart of DA server to take effect. |
| external_sort_max_size | Specifies the maximum number of rows that can be sorted in memory. Default: 1000000 Min: 2 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| external_sort_max_file | Specifies the maximum number of files used for external sort. Default: 60 Min: 10 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| external_sort_compress_file | Specifies whether or not to compress the data files. Default: false Valid values: true or false This parameter does not require a restart of DA server to take effect. |
| external_sort_activate_size | Specifies the minimum number of rows required in a database table for activating external sort. Default: 1000000 Min: 2 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| file_output_encoding | Specifies the file output encoding for all reconciliation scripts and report files. Valid values: Any character set encoding supported by the DA server Java Runtime Environment (JRE). This parameter does not require a restart of DA server to take effect. |
| lob_fetch_size | Specifies the maximum number of large object (LOB) bytes to read and compare. Default: 1024 Min: 1 Max: 1048576 This parameter does not require a restart of DA server to take effect. |
| recon_tran_max_stmts | Specifies the maximum number of statements in a reconciliation transaction. If the number of statements needed is greater than the specified number, you need multiple transactions. A value of zero means unlimited number of statements in a transaction. Default: 0 Min: 0 Max: 2147483647 This parameter does not require a restart of DA server to take effect. |
| text_report_max_column_width | Specifies the maximum column width in a text report. Default: 30 Min: 10 Max: 80 This parameter does not require a restart of DA server to take effect. |
| text_report_max_line_length | Specifies the maximum line length in a text report. Default: 200 Min: 100 Max: 1000 This parameter does not require a restart of DA server to take effect. |