T-SQL Query to check Sybase Replication connection properties
Sybase Replication RSSD, Sybase ReplicationBelow query can be used to check DSI connection level properties in Sybase Replication. Login to RSSD database and run below query to get the result.
select d.dsname + '.' + d.dbname as Server,
rc.optionname as Config_Name,
substring(rc.charvalue,1,30) as Config_Value,
case when rt.status = 1
then rt.cv
else substring(rc.charvalue,1,30)
end Run_Value
from rs_config rc,
rs_tvalues rt,
rs_databases d
where rc.optionname = rt.name
and rt.type = "CF"
and rc.objid != 0
and d.dbid = hextoint(bintostr(substring(rc.objid,1,4)))
order by Server,
Config_Name
Sample Output:
