Below 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

Login to SYB_DS database server and run the query under RSSD database.

1>use SYB_RSSD
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

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.