Psap: 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..."

2015-09-09T13:46:57Z

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..."

New page

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)

[[Category:RepServer]]

RepServer show changed configuration options - Revision history

Psap: 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..."