Difference between revisions of "RepServer show changed configuration options"
From SybaseWiki
(Created page with "You can use the below SQL statement to see the changes to the Replication Server configuration as they have been made by either rs_configure (on the ASE side) or "configure re...") |
(No difference)
|
Latest revision as of 14:46, 9 September 2015
You can use the below SQL statement to see the changes to the Replication Server configuration as they have been made by either rs_configure (on the ASE side) or "configure replication server" (on the Replication Server side).
It is assumed that you use ASE as the Replication Server System Database.
select optionname as "Option",
convert(varchar(16),dv) as "Default Value",
convert(varchar(16),charvalue) as "Config value"
from rs_config c
join rs_tvalues t
on c.optionname = t.name
and c.charvalue != t.dv
where t.type = "CF"
and t.value = 1
and not ((c.optionname = "cm_fadeout_time" and charvalue = "300")
or (c.optionname = "exec_nrm_request_limit" and c.charvalue = "8388608")
or (c.optionname = "id_security_mechanism" and c.charvalue = "")
or (c.optionname = "init_sqm_write_delay" and c.charvalue = "100")
or (c.optionname = "init_sqm_write_max_delay" and c.charvalue = "1000")
or (c.optionname = "mat_report_interval" and c.charvalue = "60")
or (c.optionname = "mem_thr_exec" and c.charvalue = "90")
or (c.optionname = "mem_thr_sqt" and c.charvalue = "85")
or (c.optionname = "memory_limit" and c.charvalue = "2047")
or (c.optionname = "sqm_cmd_cache_size" and c.charvalue = "20971520")
or (c.optionname = "sqt_max_cache_size" and c.charvalue = "20971520")
or (c.optionname = "sqt_max_prs_size" and c.charvalue = "2147483647"))
order by 1
Sample output
Option Default Value Config value ------------------------------ ---------------- ---------------- cm_max_connections 144 128 disallowed_prev_passwords 0 12 max_failed_logins 0 3 memory_limit 80 8192 min_password_len 6 8 num_client_connections 30 128 num_mutexes 1024 16777216 num_stable_queues 32 40 password_lowercase_required false true password_numeric_required false true password_uppercase_required false true simple_passwords_allowed true false sqm_recover_segs 1 4 sqm_write_flush on dio sqt_max_cache_size 1048576 200000000 sts_cachesize 1000 30000 sts_full_cache_rs_columns off on sts_full_cache_rs_config off on sts_full_cache_rs_databases off on sts_full_cache_rs_diskaffinity off on sts_full_cache_rs_objects off on sts_full_cache_rs_queues off on (22 rows affected)
