Sybase Replication: T-SQL Query to check table level replication flow details
Sybase Replication MSA, Sybase Replication, table level replication, warmstandbyBelow query needs to be run on RSSD database to check complete table level replication flow details against specific Replication server.
Login to Replication server and get RSSD details.
1>admin rssd_name
2>go

Login to SYB_DS database server and run the query under RSSD database.
1>use SYB_RSSD
2>go
1>select substring(d.dsname,1,20) "SRC_SRV", substring(d.dbname,1,15) "SRC_DB",
substring(rd.dsname,1,20) "TGT_SRV", substring(rd.dbname,1,15) "TGT_DB",
substring(o.phys_tablename,1,35) "Table_Name",substring(objname,1,30) "Replication_Def",substring(subname,1,30) "Subscription"
from rs_subscriptions s,rs_objects o, rs_databases d, rs_users u, rs_repdbs rd
where rd.dbid=s.dbid
and s.objid=o.objid
and o.dbid=d.dbid
and s.rownerid=u.uid
2>go
Sample Output:

How useful was this post?
Click on a star to rate it!
Average rating 5 / 5. Vote count: 2
No votes so far! Be the first to rate this post.