RepServer show changed configuration options

From SybaseWiki
Jump to: navigation, search

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)