Querying member subsets

You are able to query member subset information by running db2pd -membersubsetstatus command.

Procedure

Running db2pd -membersubsetstatus

with the detail option displays the failover priority. The legacy output of db2pd -membersubsetstatus is preserved.

Example

Output for db2pd -membersubsetstatus, which does not show failover information

Member Subset Id = 1   
Member Subset Name = MY_SUBS
Member Subset Creation Time = 2016-01-22-07.20.27.127120
Member Subset Enabled = YES
Include Alternate Server = YES
Inclusive = NO
Catalog Database Alias = YES
Member Priority Basis = EQUALPRIORITY
Number of Members = 4 
Database Alias = MY_DB
  
Member List
==================================================================================================
0, 1, 2, 3

Output for db2pd -membersubsetstatus detail, which shows failover information

Member Subset Id = 1
  Member Subset Name = MY_SUBS
  Member Subset Creation Time = 2016-01-22-07.20.27.127120
  Member Subset Enabled = YES
  Include Alternate Server = YES
  Inclusive = NO
  Catalog Database Alias = YES
  Member Priority Basis = EQUALPRIORITY
  Number of Members = 4
  Database Alias = MY_DB
  
  Member List          Failover Priority
  =========================================
  0                    0
  2                    1
  1                    254
  3                    254