NRG_INFO view

The NRG_INFO view returns one row 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_INFO.
  • For the authority needed to use this view, see Authorization.

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

Table 1. NRG_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.
NRG_STATE STATE VARCHAR(8) NRG state.
ACTIVE
The NRG is active.
DEGRADED
The NRG is degraded. The number of active links is less than the configured load balance link count.
FAILED
There are no active links for the NRG.
INACTIVE
The NRG is not started.
LINK_COUNT LINK_COUNT INTEGER The number of links in the NRG.
LOAD_BALANCE_LINK_COUNT BAL_COUNT INTEGER Load balance link count.
TEXT_DESCRIPTION TEXT VARCHAR(50)
Nullable
 NRG description.

Contains the null value if there is no description for this NRG.
ACTIVE_LINK_COUNT ACT_COUNT INTEGER The number of active links in the NRG.
CONNECTIONS CON_COUNT BIGINT The number of active connections for all links associated with the NRG.
LINK_FAILURES FAIL_COUNT BIGINT The cumulative number of link failures since the NRG was created.
OUTBOUND_RDMA_COUNT OUT_COUNT BIGINT Outbound RDMA count since the NRG was created.
OUTBOUND_RDMA_BYTES OUT_BYTES BIGINT Outbound RDMA bytes since the NRG was created.
OUTBOUND_RDMA_USER_COUNT OUT_USERC BIGINT Outbound user RDMA count since the NRG was created.
OUTBOUND_RDMA_USER_BYTES OUT_USERB BIGINT Outbound user RDMA bytes since the NRG was created.
OUTBOUND_MESSAGES OUT_MSG BIGINT Outbound message count since the NRG was created.
INBOUND_RDMA_COUNT IN_COUNT BIGINT Inbound RDMA count since the NRG was created.
INBOUND_RDMA_BYTES IN_BYTES BIGINT Inbound RDMA bytes since the NRG was created.
INBOUND_RDMA_USER_COUNT IN_USERC BIGINT Inbound user RDMA count since the NRG was created.
INBOUND_RDMA_USER_BYTES IN_USERB BIGINT Inbound user RDMA bytes since the NRG was created.
INBOUND_MESSAGES IN_MSG BIGINT Inbound message count since the NRG was created.

Example

  • Show all the Network Redundancy Groups that have active links.
    SELECT * FROM QSYS2.NRG_INFO
  WHERE ACTIVE_LINK_COUNT > 0;