Below query needs to be run on RSSD database to check Sybase table level replication details.

select SUBSTRING(db1.dsname,1,20) as SRC_SRV,
SUBSTRING(db1.dbname,1,20) as SRC_DB,
'—' as direction,
SUBSTRING(db2.dsname,1,20) as TGT_SRV,
SUBSTRING(db2.dbname,1,20) as TGT_DB,
SUBSTRING(ro.phys_tablename,1,40) as 'SRC_Table',
SUBSTRING(ro.deliver_as_name,1,40) as 'TGT_Table'
from … Read the rest

Many a times while working on Sybase Replication environment, we come across scenarios where we have only Source Server/Database or Target Server/Database details and we want to find out it's corresponding replication flow details. We can use below query based … Read the rest