5
(1)

Below 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:

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.