Query to check Sybase replication disk space
Sybase Replication admin disk_space, Replication, Sybase 0
(0)
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
order by rs_diskpartitions.id
Sample Output:

How useful was this post?
Click on a star to rate it!
Average rating 0 / 5. Vote count: 0
No votes so far! Be the first to rate this post.