MIGRATION_INTERFACE_INFO view

The MIGRATION_INTERFACE_INFO view returns information about interfaces that are registered in the Migrate While Active environment. The modifications registered in this list will occur during the cutover stage.

Authorization: The caller must have *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 MIG_IFCINF. The schema is QSYS2.

Table 1. MIGRATION_INTERFACE_INFO view
Column Name	System Column Name	Data Type	Description
CUTOVER_ACTION	CUT_ACTION	VARCHAR(20)	The cutover action to be performed by the Migration Manager for the associated interface. ADD ON TARGET Add the interface on the target node. MOVE TO TARGET Move the interface from the source node to the target node. REMOVE FROM SOURCE Remove the interface on the source node. REMOVE FROM TARGET Remove the interface on the target node.
IP_ADDRESS	IP_ADDRESS	VARCHAR(45)	The IP address for this action.
LINE_DESCRIPTION	LINE_DES	VARCHAR(10)	The name of the communications line description that identifies the physical network associated with the interface.
RESOURCE_NAME	RESOURCE	VARCHAR(10) Nullable	The name of the resource that identifies the communications port. Contains the null value if a name is not registered.
COMMUNICATION_PORT	COMM_PORT	VARCHAR(79) Nullable	The name of the physical location that identifies the communications port. Contains the null value if the port is not registered.
VIRTUAL_LAN_ID	LAN_ID	VARCHAR(4)	The virtual LAN in which the interface belongs to. 1-4094 The virtual LAN identifier to be used. NONE The IP address is not part of a virtual LAN.
SUBNET_MASK	SUBNET_MSK	VARCHAR(15) Nullable	The subnet mask for the network, subnet, and host address fields of the internet address that defines the subnetwork for an interface.
AUTOSTART	AUTOSTART	VARCHAR(3)	Whether the interface is automatically started when the protocol stack is activated. NO This interface is not automatically started. YES This interface is automatically started.
FAILURE_MESSAGE_ID	MSG_ID	CHAR(7) Nullable	The message ID from a failed cutover for the interface. Contains the null value if the cutover action for this interface has not failed.
FAILURE_MESSAGE_TEXT	MSG_TEXT	VARGRAPHIC(1024) CCSID 1200 Nullable	First level message text corresponding to FAILURE_MESSAGE_ID. Contains the null value if the cutover action for this interface has not failed.
PROCESSING_START_TIME	START_TIME	TIMESTAMP Nullable	Timestamp when cutover processing started for this interface. Contains the null value if the cutover action for this interface has not started.
PROCESSING_END_TIME	END_TIME	TIMESTAMP Nullable	Timestamp when cutover processing completed for this interface. Contains the null value if the cutover action for this interface has not ended or failed.

Example

Review the list of interface changes that will be processed during the cutover stage.
```
SELECT * FROM QSYS2.MIGRATION_INTERFACE_INFO;
```