• Search for:

    Monthly Archives: January 2022

    1. Home  - 2022  - 
    2. January
    8 Jan, 2022
    How to check MSA replication details in Sybase 5 (1)
    Sybase Replication

    Below query can be run on RSSD database server to check MSA (Multi Site Availability) replication flow details in Sybase. 

       select convert(varchar(20),src.dsname)+"."+convert(varchar(20),src.dbname) as "Primary SRVR.DB",
          convert(varchar(20),trg.dsname)+"."+convert(varchar(20),trg.dbname) as "Target SRVR.DB",convert(varchar(20),dbrepname) as "DBRepDef",
          'MSA' as Type
     from rs_databases src, rs_databases trg, rs_subscriptions
    … Read the rest