Skip to Content
0

Subscriptions to table replication definition

Jul 13, 2017 at 06:08 PM

37

avatar image

is there any way to check if a table-level (not database-level) replca definition has subscriptions.

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

1 Answer

Avinash Kothare Jul 13, 2017 at 09:05 PM
0

Yes. in RSSD or eRSSD

1. First

execute rs_helpreptable <DBName>, <TableName>

This will show the repdefs for that table.

2. Then for each repdef

execute rs_helprep <repdef_name>

At the bottom of the output it will show you the subscription name(s) for that repdef

3. You can also further check about where the replicated data is going

execute rs_helpsub <repsub name>

HTH

Avinash

See the attachment for examplerepdef-and-repsub-for-a-table.txt


Show 1 Share
10 |10000 characters needed characters left characters exceeded

I already have de replication definitions for the tables, but I can´t see subscriptions on them. And

What strikes me most is that the databases are replicated at the database level, but also have table replication definitions. Maybe was doing for eficiency.

I will follow the steps you mention

Thanks a lot for your help

0