• Search for:

    Category Archives: Sybase Replication

    1. Home  - 
    2. Archive by category "Sybase Replication"
      3. ( Page2 )
    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
    31 Dec, 2021
    Query to check Sybase replication disk space 0 (0)
    Sybase Replication , ,

    Below query can be used to check Sybase replication disk space usage.

    select 'Partition_Name'=substring(name,1,30),'Logical_Name'=substring(logical_name,1,10),id as 'Partition_Id',num_segs as 'Total_Segs',SUM(rs_segments.used_flag) as 'Used_Segs',
    CASE
    when status =1 then "On-Line"
    else "Off-Line"
    END as State
    from rs_diskpartitions join rs_segments
    ON rs_diskpartitions.id=rs_segments.partition_id
    group by rs_diskpartitions.id    … Read the rest