How to check publication / subscription with sybase replication ?

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 ?
motioneyeAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

drittenhCommented:
Hi Motioneye,

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

eg.  isql -U -P -S etc etc

use <rssd_name>
go

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

For RSSD schema check out:

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc70003.1550/pdf/rs155pst.pdf?noframes=true

HTH,

- David
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
alpmoonCommented:
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%'  

0
BenSladeCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Sybase Database

From novice to tech pro — start learning today.