Question
Kamal Suri · Nov 23

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
00
2 0 4 99
Log in or sign up to continue

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! laugh

Thanks Jeffrey ..