1

How to get the code of all replication definitions of a Sybase server?

If possible and since I'm new to this, give me a little explanation on them as well.

aF.
  • 64,980
  • 43
  • 135
  • 198

2 Answers2

3

Much of the information about your replication system can be found using the various help functions in the RSSD/ERSSD. The specific commands will vary somewhat based on the kind of Replication you are using (Warm Standby, Function String, Table, Procedure, mixed).

rs_helpdb [ dataserver, database ]: Shows all databases known by the RSSD. If you specify dataserver/datbase, it will only show information for that connection. Output lists Server/Database, rep dbid, primary RS, errorclass, repserver errorclass, function class and status.

rs_helprepdb: Shows replicate databases that have subscriptions to primary data in the current RS, or shows the specified DS/DB.

Other commands that will help:

rs_helprep Displays information about replication definitions

rs_helpsub Displays information about subscriptions

rs_helpreptable Displays information about replication definitions created against a primary table.

rs_helppub Displays information about publications.

rs_helppubsub Displays information about publication subscriptions and article subscriptions.

rs_helpdbrep Displays information about database replication definitions associated with the current Replication Server

rs_helpdbsub Displays information about database subscriptions associated with the replicate data server.

These commands all pull information from the tables in the RSSD, so you can also poke around the RSSD to find the information you are looking for. Here is the RS table diagram to help.

Also, if you are going to do any regular replication work, I highly recommend Rob Verschoors The Complete Sybase Replication Server Quick Reference Guide (www.sypron.nl), as it has >90% of what you need to create and manage a Sybase rep environment.

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34
1
  • you can use Replication Monitoring Services (RMS)
  • Various stored procedures and shell scripts for reverse-engineering RepServer objects can be downloaded from http://repserver.codexchange.sybase.com (link 'repserver', folder Admin Tools/Scripts)
  • PowerDesigner provides reverse-engineering but might require a special license
Vince
  • 734
  • 1
  • 5
  • 10
  • 1
    Unfortunately, since Sybase was bought by SAP, the codexchange.sybase.com website is gone. Also note, as of repserver 15.7.1 the RMS product is no longer included with the repserver distribution. The documentation web pages say to download it from the "Sybase" website (which doesn't exist anymore, it just redirects to sap.com). I tried a search the SAP Support Portal, but RMS wasn't found. It sounds like RMS might be going away. – Ben Slade Nov 18 '15 at 15:19