Dropping members in a member subset

You are able to drop members in a member subset.

Before you begin

  • The FAILOVER_PRIORITY attribute should not be specified when you are dropping a member from the subset.
  • The DROP clause is processed only if the resulting subset has at least one primary member.

Procedure

To drop a member, call this procedure: CALL SYSPROC.WLM_ALTER_MEMBER_SUBSET( '<subset_name>', NULL, '( DROP <memberId>)' )
If the resulting subset has at least one primary member, any member in the subset can be dropped.

Example

Consider the following "SALES_PREFERED_SUBSET" subset

Table 1. SYSCAT.MEMBERSUBSETMEMBERS
SUBSETID MEMBERS FAILOVER_PRIORITY
1 0 0
1 1 1
To drop member 1, run this procedure: 
CALL SYSPROC.WLM_ALTER_MEMBER_SUBSET( 'SALES_PREFERRED_SUBSET', NULL, '( DROP 1)' )
Resulting subset:
Table 2. SYSCAT.MEMBERSUBSETMEMBERS
SUBSETID MEMBERS FAILOVER_PRIORITY
1 0 0