Mirror Member List
Hi,
What's the best way to get list of members attached to a Mirror?
In my scenario, in a Mirror set there are 5 members. 2 Failover, 2 DR Async and 1 R/W reporting.
On Primary, in the code I want to identify Backup member and then do my stuff.
And on Backup, in the code I want to identify DR Async and then do my stuff.
Basically the idea is to push file through code from Primary > Backup and then later files will be pushed from Backup > DR Async.
Regards
Kamal Suri
Product version: IRIS 2020.1
Discussion (4)2
Comments
The class query MemberStatusList in SYS.Mirror (found in the %SYS namespace) will give you a list of mirror members and some useful status information:
%SYS>d ##class(%ResultSet).RunQuery("SYS.Mirror","MemberStatusList")
Member Name:Current Role:Current Status:Journal Transfer Latency:Dejournal Latency:Journal Transfer Latency:Dejournal Latency:Display Type:Display Status:
MDCHCNDBSL1.HICGRP.COM/STAGE:Primary:Active:N/A:N/A:N/A:N/A:Failover:Primary:
MDCHCNDBSL2.HICGRP.COM/STAGE:Backup:Active:Active:Caught up:Active:Caught up:Failover:Backup:
CDCHCNDRSL.HICGRP.COM/STAGE:Async:Async:Caught up:Caught up:Caught up:Caught up:Disaster Recovery:Connected:You beat me to this one by seconds! 
Thanks Vic..
Thanks Jeffrey ..