RDMA_CONNECTION_INFO view

The RDMA_CONNECTION_INFO view returns one row for each Remote Direct Memory Access (RDMA) connection.

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

For the authority needed to use this view, see Authorization.
*EXECUTE authority on the QSYS2 library.
*OBJOPR and *READ authority on QSYS2/RDMA_CON.
*IOSYSCFG special authority or be authorized to the QIBM_IOSYSCFG_VIEW function usage identifier.

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

Table 1. RDMA_CONNECTION_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.
SOURCE_PORT	SRC_PORT	INTEGER	Port number for this connection on the local node.
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.
TARGET_PORT	TGT_PORT	INTEGER	Port number for this connection on the remote node.
CONNECTION_STATE	STATE	VARCHAR(11)	State of the connection. CONNECTING An attempt to establish a connection to the remote host is being made. ERROR The connection is in error. ESTABLISHED The normal state in which data is transferred. LISTEN Waiting for a connection request from a remote host.
CONNECTION_ERROR	ERROR	INTEGER	The error code associated with the socket if `CONNECTION_STATE` is `ERROR`.
NRG_NAME	NRG_NAME	VARCHAR(15)	The Network Redundancy Group (NRG) name.
JOB_NAME_COUNT	JOB_COUNT	SMALLINT	The number of job name entries in the `JOB_NAME` column.
JOB_NAME	JOB_NAME	VARCHAR(2899)	A list of up to 100 qualified job names for the connection endpoint. The list is an array of 29 character entries which guarantees at least one blank between entries.
IDLE_TIME	IDLE_TIME	DECIMAL(19,3)	Idle time, in seconds, since the last activity on this connection.
SEND_BUFFER_SIZE	SEND_SIZE	INTEGER	Size of send buffer, in bytes.
RECEIVE_BUFFER_SIZE	RCV_SIZE	INTEGER	Size of receive buffer, in bytes.
REQUESTS_IN	REQ_IN	INTEGER	The number of incoming requests.
REQUESTS_OUT	REQ_OUT	INTEGER	The number of outgoing requests.
BYTES_IN	BYTES_IN	BIGINT	The number of incoming bytes.
BYTES_OUT	BYTES_OUT	BIGINT	The number of outgoing bytes.
OUTSTANDING_SEND_REQUESTS	SND_REQ	INTEGER	The number of outstanding send requests issued that have not yet completed.
OUTSTANDING_USER_SEND_ REQUESTS	USRSND_REQ	INTEGER	The number of outstanding user RDMA send requests issued that have not yet completed.
OUTSTANDING_USER_RECEIVE_ REQUESTS	USRRCV_REQ	INTEGER	The number of outstanding user RDMA receive requests issued that have not yet completed.
BUFFER_WAITS	BUF_WAITS	INTEGER	The number of times that send operations have had to wait for available space in the remote receive buffer in order to send data.
WAIT_TIME_ON_REMOTE_RECEIVE_ BUFFER	WAIT_TIME	DECIMAL(19,3)	The total time, in seconds, that send operations have had to wait for available space in the remote receive buffer in order to send data.

Example

Examine any connections that are currently in the error state.

SELECT * FROM QSYS2.RDMA_CONNECTION_INFO
  WHERE CONNECTION_STATE = 'ERROR';