NRG_LINK_INFO view

The NRG_LINK_INFO view returns one row for each link defined for each Network Redundancy Group (NRG).

Authorization: The privileges held by the authorization ID of the statement must include the following:

*EXECUTE authority on the QSYS2 library.
*OBJOPR and *READ authority on QSYS2/NRG_LINK.
For the authority needed to use this view, see Authorization.

The following table describes the columns in the view. The system name is NRG_LINK. The schema is QSYS2.

Table 1. NRG_LINK_INFO view
Column Name	System Column Name	Data Type	Description
NRG_NAME	NRG_NAME	VARCHAR(15)	NRG name. MIRROR_DATABASE NRG for immediate replication of database-related objects and operations. 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. MIRROR_RESYNC NRG for resynchronization of objects and data that were changed while replication was suspended.
ADDRESS_SPACE_TYPE	ADDR_TYPE	CHAR(4)	The IP address space type for `SOURCE_ADDRESS` and `TARGET_ADDRESS`. IPV4 The address is specified using the IPv4 address space type. IPV6 The address is specified using the IPv6 address space type.
SOURCE_ADDRESS	SRC_ADDR	VARCHAR(45)	Local IP address for this link. When `ADDRESS_SPACE_TYPE` is `IPV4`, the address is in IPv4 format. When `ADDRESS_SPACE_TYPE` is `IPV6`, the address is in IPv6 format.
TARGET_ADDRESS	TGT_ADDR	VARCHAR(45)	Remote IP address for this link. When `ADDRESS_SPACE_TYPE` is `IPV4`, the address is in IPv4 format. When `ADDRESS_SPACE_TYPE` is `IPV6`, the address is in IPv6 format.
LINK_STATE	STATE	VARCHAR(4)	The state of the link. DOWN The link is not available. UP The link is available.
LINK_PRIORITY	PRIORITY	INTEGER	Link priority. Values are 1 to 16 where 1 is the highest priority.
LINK_IN_USE	IN_USE	VARCHAR(3)	Indicates whether this link is being used. If the load balance link count is less than the number of active links in the NRG, some active links are not used by the NRG. NO The link is not being used. YES The link is being used.
LINE_DESCRIPTION	LINE_DES	VARCHAR(10) Nullable	The local system line description associated with this connection. Contains the null value if this is an IPv4 link or if an IPv6 link does not have a line description.
VIRTUAL_LAN_ID	LAN_ID	INTEGER Nullable	The virtual LAN identifier associated with this connection. Contains the null value if this is an IPv4 link or if an IPv6 link does not have a virtual LAN identifier.
RDMA_TYPE	RDMA_TYPE	VARCHAR(17)	The type of RDMA protocol used by this link. ROCE V1 RoCE version 1 is a non-encrypted and non-routable RDMA protocol. It transfers data using the Ethernet link layer protocol with Ethertype 0x8915 which allows communication between two hosts within the same Ethernet broadcast domain. Communicating host IP addresses must be in the same Ethernet broadcast domain and in the same subnet. This type of link will start only if non-encrypted RDMA is allowed in your environment. ROCE V2 RoCE version 2 is a non-encrypted and routable RDMA protocol. It is an internet layer protocol which enables packets to be routed. Data is not encrypted and is transferred using the UDP protocol and UDP destination port number 4791. This type of link will start only if non-encrypted RDMA is allowed in your environment. ENCRYPTED ROCE V2 Encrypted RoCE version 2 is an encrypted and routable RDMA protocol. RoCE version 2 with IPsec encryption is an internet layer protocol which enables packets to be routed securely by using IPsec protocols to provide data authentication, integrity, and confidentiality. A VPN connection must be configured for each RDMA link endpoint with data transforms (encryption protocols) supported by the adapter. A VPN connection must be available for the RDMA link to start. If the VPN connection is ended, the RDMA link is also ended. Data is encrypted using IPsec and transferred using the UDP protocol and UDP destination port number 4791.
VPN_NAME	VPN_NAME	VARCHAR(40) Nullable	The name of the virtual private network (VPN) connection associated with this link. Contains the null value for non-encrypted RDMA types or if a VPN connection for the link is not configured.

Example

Review all the links that are defined for Network Redundancy Groups.

SELECT * FROM QSYS2.NRG_LINK_INFO
  ORDER BY NRG_NAME, LINK_PRIORITY;