How to check publication / subscription with sybase replication ?

Posted on 2011-05-09
Last Modified: 2012-05-11
when I ran rs_helpdb, I can see it output me results, then I try to find out publication exist in the db,. I ran sp_helppub, unfortunately it does not show me any result. but I'm sure we have configure replication in our server. How to check for publication then ?
Question by:motioneye
    LVL 2

    Accepted Solution

    Hi Motioneye,

    Log into the RSSD and query the table directly...

    eg.  isql -U -P -S etc etc

    use <rssd_name>

    select * from rs_subscriptions where subname like '%part_of_your_sub_name%'  

    For RSSD schema check out:


    - David
    LVL 13

    Assisted Solution

    It is a good idea to check RSSD system tables. However, you can check publications in rs_publications. So it should be

    select * from rs_publications where pubname like '%part_of_your_sub_name%'  

    LVL 1

    Assisted Solution

    There are various stored procs you can use in the RSSD db to get info, but you need to use the different stored proc's for different types of replication.

    For warm standby replication you can use the command in the repserver:
    > admin logical_status

    For non-publication subscription replication, on the RSSD use:
    > rs_helprep    -- on the primary repserver RSSD, if you have multiple repservers
    > rs_helpsub

    For publication based subscriptions:
    > rs_helprep
    > rs_helppub
    > rs_helppubsub     -- Note, this won't show non-publication subscription

    For whole database replication subscriptions (aka Multi Site Availability, MSA):
    > rs_helprepdb  -- list all MSA replicated db's
    > rs_helpdbrep  -- list db replication definitions (should be callled sp_helpdbrepdef)
    > rs_helpdbsub

    The Complete Sybase Replication Server Quick Reference Guide by Rob Verschoor is really useful to keep track of all this stuff.

    Ben Slade

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now