SAP (sybase) RS - some basic and useful scripts and queries

Select RS version

1. Login RS and run:

admin version

2. Without login:

cd $SYBASE/REP-16_0/bin/

repserver -v

A list of running / not running components

admin who

admin who_is_down

(Executed from RS)

Get the name and path of the RS log

admin log_name

(Executed from RS)

Information about databases and replication definitions

select * from rs_databases

select * from rs_subscriptions

select * from rs_publications

select * from rs_dbreps

exec rs_helpdb

exec rs_helprep

exec rs_helpsub

(Executed from RSSD databse)