MIRROR_CLUSTER_INFO view

The MIRROR_CLUSTER_INFO view returns one row containing the cluster configuration information of the Db2® Mirror nodes.

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/CLUST_INFO.
  • Start of change*IOSYSCFG special authority or be authorized to the QIBM_IOSYSCFG_VIEW function usage identifier.End of change

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

Table 1. MIRROR_CLUSTER_INFO view
Column Name System Column Name Data Type Description
CLUSTER_NAME CLUSTER VARCHAR(10) The cluster name.
DEVICE_DOMAIN_NAME DEV_DOMAIN VARCHAR(10) The device domain name.
PRIMARY_NODE_NAME PRIMARY VARCHAR(8) The cluster node id of the primary node.
PRIMARY_NODE_PRIMARY_IP PRI_IP1 VARCHAR(45) The preferred IP address in IPv4 or IPv6 format for the primary node that can be used by Cluster Resource Services to communicate with other nodes in the cluster.
PRIMARY_NODE_SECONDARY_IP PRI_IP2 VARCHAR(45)
Nullable
 A second IP address in IPv4 or IPv6 format for the primary node that can be used by Cluster Resource Services to communicate with other nodes in the cluster.

Contains the null value when a second IP address is not configured.
SECONDARY_NODE_NAME SECONDARY VARCHAR(8) The cluster node id of the secondary node..
SECONDARY_NODE_PRIMARY_IP SEC_IP1 VARCHAR(45) The preferred IP address in IPv4 or IPv6 format for the secondary node that can be used by Cluster Resource Services to communicate with other nodes in the cluster.
SECONDARY_NODE_SECONDARY_IP SEC_IP2 VARCHAR(45)
Nullable
 A second IP address in IPv4 or IPv6 format for the secondary node that can be used by Cluster Resource Services to communicate with other nodes in the cluster.

Contains the null value when a second IP address is not configured.

Example

  • View the cluster information about the Db2 Mirror nodes.
    SELECT * FROM QSYS2.MIRROR_CLUSTER_INFO;