MIRROR_TAKEOVER_INFO view

The MIRROR_TAKEOVER_INFO view returns one row for each IP address that has been registered as part of a takeover IP address group. It also returns one row for any takeover IP address group that is defined but contains no IP addresses.

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/MIR_TO_INF.
For the authority needed to use this view, see Authorization.

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

Table 1. MIRROR_TAKEOVER_INFO view
Column Name	System Column Name	Data Type	Description
GROUP_NAME	GROUP_NAME	VARCHAR(10)	The name of the takeover IP address group.
ADDRESS_SPACE_TYPE	ADDR_TYPE	CHAR(4) Nullable	The IP address space type for `LOCAL_ADDRESS`. IPV4 The address is specified using the IPv4 address space type. IPV6 The address is specified using the IPv6 address space type. Contains the null value if the takeover IP address group contains no IP addresses or if the CRG for the takeover IP address group is not found.
LOCAL_ADDRESS	LOCAL_ADDR	VARCHAR(45) Nullable	Local IP address. When `ADDRESS_SPACE_TYPE` is `IPV4`, the address is in IPv4 format. When `ADDRESS_SPACE_TYPE` is `IPV6`, the address is in IPv6 format. Contains the null value if the takeover IP address group contains no IP addresses or if the CRG for the takeover IP address group is not found.
IASP_NAME	IASP_NAME	VARCHAR(10)	Name of the independent ASP group containing the takeover IP address group. Contains either the name of the ASP group or the following special value: *SYSBAS This takeover IP address group is for the system ASP (ASP 1) and any basic user ASPs (ASPs 2-32).
PREFERRED_NODE	PREFERRED	VARCHAR(8) Nullable	The name of the partition that was registered as the preferred node when the takeover IP address group was defined. Contains the null value if the CRG for the takeover IP address group is not found.
CURRENT_NODE	CURRENT	VARCHAR(8) Nullable	The name of the takeover IP address group's current node. Contains the null value if the CRG for the takeover IP address group is not found.
AUTO_SWITCHBACK	AUTOSWITCH	VARCHAR(3)	Whether this takeover IP address group should be automatically switched back to its preferred node when the node returns to ACTIVE state. NO Manual intervention is needed to return this takeover IP address group to its preferred node. YES The system will automatically return this takeover IP address group to its preferred node.
TEXT_DESCRIPTION	TEXT	VARCHAR(50) Nullable	Description of the takeover IP address group. Contains the null value if there is no text description or if the CRG for the takeover IP address group is not found.

Example

Identify any takeover IP address groups and IP addresses that are not currently active on their preferred node.

SELECT * FROM QSYS2.MIRROR_TAKEOVER_INFO
  WHERE CURRENT NODE IS NOT NULL AND
        CURRENT_NODE <> PREFERRED_NODE;