Altering failover priority

You can use the FAILOVER_PRIORITY attribute in the WLM_ALTER_MEMBER_SUBSET procedure to change the failover priority.

Before you begin

The member in ALTER clause should already be present in the subset.
The ALTER clause is only processed if the resulting subset has at least one primary member

You can change the failover priority immediately by using the ALTER command.

To change a member's failover priority, call this procedure:

CALL SYSPROC.WLM_ALTER_MEMBER_SUBSET( '<subset_name>', NULL, '( ALTER <memberId> FAILOVER_PRIORITY <failover_priority_number>)' )

Remember: The ALTER clause is only processed if the resulting subset has at least one primary member.

Consider the following "SALES_PREFERRED_SUBSET" subset:

Table 1. SYSCAT.MEMBERSUBSETMEMBERS
SUBSETID	MEMBERS	FAILOVER_PRIORITY
1	0	0
1	1	0

To change member 1's failover priority from 0 to 1, run this procedure:

CALL SYSPROC.WLM_ALTER_MEMBER_SUBSET( 'SALES_PREFERRED_SUBSET', NULL, '( ALTER 1 FAILOVER_PRIORITY 1)' )

Resulting subset:

Table 2. SYSCAT.MEMBERSUBSETMEMBERS
SUBSETID	MEMBERS	FAILOVER_PRIORITY
1	0	0
1	1	1