Skip to Content
avatar image
Former Member

Subscriptions to table replication definition

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 13, 2017 at 09:05 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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