REMOVE_NRG_LINK procedure

The REMOVE_NRG_LINK procedure removes a link from one or all of the Db2® Mirror Network Redundancy Groups (NRGs). This can only be done if the network redundancy group (NRG) has a state of INACTIVE. If the link is the only remaining link in an NRG, the NRG will also be removed.

Authorization: The privileges held by the authorization ID of the statement must include *IOSYSCFG special authority. For the authority needed to use this procedure, see Authorization.

Read syntax diagramSkip visual syntax diagram REMOVE_NRG_LINK ( NRG_NAME =>  nrg-name , SOURCE_ADDRESS =>  source-address ,DECREMENT_LOAD_BALANCE_LINK_COUNT => decrement-load-balance-link-count,LINE_DESCRIPTION => line-description,VIRTUAL_LAN_ID => virtual-lan-id )

The schema is QSYS2.

nrg-name
A character or graphic string that contains the name of the NRG where the link is to be removed.
The valid NRG names and their primary uses are:
MIRROR_DATABASE
NRG for immediate replication of database-related objects and operations.
  • Object types: *DTAARA, *ENVVAR, *FILE, *JOBD, *JRN, *LIB, *PGM, *SQLPKG, *SQLUDT, *SQLXSR, *SRVPGM, and *SYSVAL
  • SQL Data Definition Language operations.
  • Start of changeReplication due to the restore of an object.End of change
MIRROR_ENGINE
NRG used by the Db2 Mirror engine to manage the Db2 Mirror environment.
MIRROR_IFS
NRG used for accessing Integrated File System (IFS) data.
MIRROR_OTHER
NRG for immediate replication of security objects, security attributes, and non-database objects or operations.
  • Object types: *AUTL, *DTAQ, *FCNUSG, *JOBQ, *OUTQ, *SECATR, *SPLF, Start of change*USRIDX,End of change *USRPRF, and Start of change*USRSPCEnd of change.
  • Replication of objects due to Replication Criteria List changes.
  • Comparison of objects between the two nodes.
MIRROR_RESYNC
NRG for resynchronization of objects and data that were changed while replication was suspended.
The following special value is also allowed.
*MIRROR
This link will be removed from all of the Db2 Mirror NRGs.
source-address
A character or graphic string that contains the local IP address for the link to remove. Either an IPv4 or an IPv6 address can be specified. Can also contain the following special value:
*ALL
Remove all links for this NRG.
decrement-load-balance-link-count
A character or graphic string that indicate whether to decrement the load balance link count.
NO
The load balance link count will remain at its current value.
YES
The load balance link count will be decremented by one. This is the default.
After being adjusted, the load balance link count must be a value from 1 to 16.

This parameter is optional.

line-description
A character or graphic string that contains the local system line description associated with this link. This parameter is optional and only applies when source-address is an IPv6 link-local address and is used to identify a unique local interface. It is ignored for all other addresses.
virtual-lan-id
An integer value for the local virtual LAN identifier associated with this link. This parameter is optional and only applies when source-address is an IPv6 link-local address and is used to identify a unique local interface. It is ignored for all other addresses.

Example

  • Remove a link from all Network Redundancy Groups on the source node. Decrease the load balance link count.
    CALL QSYS2.REMOVE_NRG_LINK(NRG_NAME => '*MIRROR',
                           SOURCE_ADDRESS => '9.5.94.95',
                           DECREMENT_LOAD_BALANCE_LINK_COUNT => 'YES');