Stable Device usage in Sybase Replication server

[Joshi]

Connect on the RSSD :

1>use RSSD
2>go
Used by the route (RSI) :
1>select si.name,"space used"=count(si.name),rs.suspended
2>from rs_segments seg,rs_sites si,rs_routes rs
3>where seg.q_number = si.id and seg.q_number >= 16777317
4>and seg.used_flag > 0 and si.id = rs.dest_rsid group by si.name,rs.suspended
5>go
name space used suspended
------------------------------ ----------- ---------
FRENCH_RS 2 0 (0 active route)
GB_RS 2 0 DEUTCH_RS 30 0

Used by the Dsi (outbound queue):

1>select dsname+" ---> "+dbname,"Space used"=count(db.dbname), db.dist_status
2>from rs_segments seg, rs_databases db
3>where seg.q_number = db.dbid and seg.q_type = 0 and
4>seg.q_number <= 16777317 and seg.used_flag > 0 group by db.dsname,db.dbname
dist_status Space used
------------------------------------------------------------------ ----------- -----------
FRENCH ---> DBTEST 1 1 (1 dsi connected)

Used by the Dsi (inbound queue) :

1>select dsname+" >--> "+ "Space used"=dbname,count(db.dbname), db.dist_status
2>from rs_segments seg, rs_databases db
3>where seg.q_number = db.dbid and seg.q_type = 1 and
4>seg.q_number <= 16777317 and seg.used_flag > 0 group by db.dsname,db.dbname
dist_status Space used
------------------------------------------------------------------ ----------- ----------- PRIMSQL >--> DBTEST 1 1
DSPRIM >--> PRIMSQL_RS_RSSD 1 1 (1 dsi connected)