config

Configures and shows DA server configuration parameters.

Syntax

config [parameter_name [parameter_value]]

Parameters

parameter_name – the DA server parameter to be set.
parameter_value – the value of the DA server parameter.

The current values of all the global configuration parameters are stored in the Data Assurance System Database (DASD).

Global Configuration Parameters
parameter_name	parameter_value
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.
clt_password_encryption_reqd	Determines the level of password encryption the server requires. Default: 0 Valid values: 0 – allows the client to choose the encryption algorithm used for login passwords on the network, including no password encryption. 1 – restricts clients to use only the RSA encryption algorithms to encrypt login passwords on the network. This provides strong RSA encryption of passwords. Clients that attempt to connect without using the RSA encryption fail. 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.

Examples

Example 1 – shows all the configuration parameters:

config 
go

The returned result is:

NAME                                   VALUE   PENDING   REQUIRE RESTART
-------------------------------------  -----   -------   ---------------
agent_access_timeout_mins                60                  false
agent_client_ctx_timeout                 5                   false
agent_max_queue                          1000                false
agent_max_request_queue                  100                 true
auto_recon_stmt_batch_size               100                 false
clt_password_encryption_reqd             1                   false  
comparer_max_concurrent_threads          5                   false    
comparer_recently_finished_ttl_secs      300                 false    
comparer_retry_delay_threshold_secs      20                  false 
comparer_retry_max_keys_per_clause       10                  false
comparer_retry_min_fill_percent          10                  false
comparer_retry_min_fill_percent_literal  90                  false  
comparer_retry_min_keys_in_range         5                   false  
db_connection_retry_interval             3                   false     
db_connection_retry_times                2                   false   
db_hash_ase_algorithm                    MD5                 false 
db_hash_ase_ignore_null                  false               false 
db_hash_ase_using_option                 UNICODE_LSB         false 
default_column_compare_mode              ROW_HASH            false
enable_report_generator                  true                false
external_sort_activate_size              1000000             false 
external_sort_compress_file              false               false 
external_sort_max_file                   64                  false      
external_sort_max_size                   100000              false   
external_sort_max_thread                 5                   false
file_output_encoding                     cp936               false 
lob_fetch_size                           1024                false 
recon_tran_max_stmts                     0                   false  
text_report_max_column_width             30                  false 
text_report_max_line_length              200                 false

Example 2 – changes the default value (MD5) for db_hash_ase_algorithm to a SHA:

config db_hash_ase_algorithm SHA        
go

The returned result is:

 
 NAME                                    VALUE       PENDING 
 --------------------------------------- ----------- ------- 
 db_hash_ase_algorithm                   SHA 
(1 rows affected)
 DEFAULT VALID       EXPLANATION
 ------- ---------  ----------------------------------------
 MD5     MD5,SHA      The database hash algorithm for ASE

Example 3 – changes the required encryption level to “encryption level 1”. If you set this configuration parameter to a nonzero value, you see a warning message.

config clt_password_encryption_reqd 1        
go

The returned result is:

[#90] Warning: you have set the password encryption level to 1; please ensure your client tool supports this level of encryption, 
otherwise you will not be able to login again without upgrading your client tool.

(1 row affected)