Appendix C Useful Queries
The queries presented here can be used by the Replication Server DBA to get information directly from RSSD system tables.
Find databases controlled by a particular Replication Server:
select dsname, dbname from rs_databases, rs_siteswhere prsid = id and name = replication_server
Check header information for all logged transactions intended for a particular query:
select * from rs_exceptshdrwhere error_site = data_serverand error_db = databaseorder by log_time
View complete information about a transaction in the exception ...
Get Sybase 15.0 Replication Server Administration now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
