Skip to Content
0

Finding source . and its definitions and subscriptions for a replication thread

Feb 05, 2017 at 06:25 AM

115

avatar image
Former Member

Hi all,

Can some help me with below:

Finding source <Servername>.<DatabaseName> and its definitions and subscriptions for a replication thread.

Example: I f I have below details -

Spid Name State Info
---- ---------- -------------------- ----------------------------------------
373 DSI EXEC Awaiting Command 591(1) sserver01.mydb
157 DSI Awaiting Message 591 sserver01.mydb
235 DIST Awaiting Wakeup 591 sserver01.mydb
332 SQT Awaiting Wakeup 591:1 DIST sserver01.mydb
11 SQM Awaiting Message 591:1 sserver01.mydb
10 SQM Awaiting Message 591:0 sserver01.mydb

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mark A Parsons Feb 05, 2017 at 03:02 PM
0

Take a look at this thread: http://nntp-archive.sybase.com/nntp-archive/action/article/%3C4ab748b7.951.1681692777@sybase.com%3E

While I can't vouch for the up-to-date accuracy of the 4-way UNION, SRS still functions as explained in the thread.

As for the 4-way UNION ... I'd suggest reviewing the source code of the various rs_help* stored procs (found in the RSSD) and then update the 4-way UNION as you see fit.

Share
10 |10000 characters needed characters left characters exceeded