RDMA_LINK_INFO view

The RDMA_LINK_INFO view returns one row for each Remote Direct Memory Access (RDMA) link. The information represents all RDMAs, not just a single 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/RDMA_LINK.
For the authority needed to use this view, see Authorization.

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

Table 1. RDMA_LINK_INFO view
Column Name	System Column Name	Data Type	Description
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.
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.
ACTIVE_CONNECTIONS	ACT_CONN	BIGINT	The number of active connections for this link.
PASSIVE_CONNECTIONS	PASS_CONN	BIGINT	The number of passive connections for this link.
LINK_FAILURES	FAIL_COUNT	BIGINT	The cumulative number of link failures since the link was first established.
OUTBOUND_RDMA_COUNT	OUT_COUNT	BIGINT	Outbound RDMA count since the link was first established.
OUTBOUND_RDMA_BYTES	OUT_BYTES	BIGINT	Outbound RDMA bytes since the link was first established.
OUTBOUND_RDMA_USER_COUNT	OUT_USERC	BIGINT	Outbound user RDMA count since the link was first established.
OUTBOUND_RDMA_USER_BYTES	OUT_USERB	BIGINT	Outbound user RDMA bytes since the link was first established
OUTBOUND_MESSAGES	OUT_MSG	BIGINT	Outbound message count since the link was first established.
INBOUND_RDMA_COUNT	IN_COUNT	BIGINT	Inbound RDMA count since the link was first established.
INBOUND_RDMA_BYTES	IN_BYTES	BIGINT	Inbound RDMA bytes since the link was first established.
INBOUND_RDMA_USER_COUNT	IN_USERC	BIGINT	Inbound user RDMA count since the link was first established.
INBOUND_RDMA_USER_BYTES	IN_USERB	BIGINT	Inbound user RDMA bytes since the link was first established.
INBOUND_MESSAGES	IN_MSG	BIGINT	Inbound message count since the link was first established.
ACK_RESPONSE_NOT_RECEIVED	ACK_NOTRCV	INTEGER	The number of times an ACK response wasn't received within the timeout since the link was first established.
DROPPED_PACKETS	DROP_PKT	INTEGER	The number of packets received but dropped due to lack of buffer space since the link was first established.
OUT_OF_SEQUENCE_PACKETS	OUTSEQ_PKT	INTEGER	The number of packets received out of sequence since the link was first established.
DUPLICATE_PACKETS	DUP_PKT	INTEGER	The number of duplicate packets received since the link was first established.
SEQUENCE_ERROR_PACKETS	SEQERR_PKT	INTEGER	The number of sequence error NAK packets received since the link was first established.
RNR_NAK_PACKETS_RECEIVED	RNR_RCV	INTEGER	The number of receiver not ready (RNR) NAK packets received since the link was first established.
RNR_NAK_PACKETS_SENT	RNR_SENT	INTEGER	The number of receiver not ready (RNR) NAK packets sent since the link was first established.

Example

Examine the links that have the heaviest outbound traffic.

SELECT * FROM QSYS2.RDMA_LINK_INFO
  ORDER BY OUTBOUND_RDMA_BYTES DESC;