MIGRATION_ROUTE_INFO view

The MIGRATION_ROUTE_INFO view returns information about routes 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_RTEINF. The schema is QSYS2.

Table 1. MIGRATION_ROUTE_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. REMOVE FROM TARGET Remove the interface from the target node.
ROUTE_DESTINATION	ROUTE_DEST	VARCHAR(45)	The IP address of the destination reached by this route. Can contain the following special value: *DFTROUTE The default route is used.
NEXT_HOP	NEXT_HOP	VARCHAR(45)	The IP address of the next gateway on the route.
SUBNET_MASK	SUBNET_MSK	VARCHAR(15) Nullable	The actual value of the subnet mask for the route destination in dotted-decimal notation. Can contain the following special value: *NONE No subnet mask is defined.
BINDING_INTERFACE	BIND_IFC	VARCHAR(15)	The IP address to bind to this route. Can contain the following special value: *NONE No IP address is bound to this route.
MAXIMUM_TRANSMISSION_UNIT	MTU	VARCHAR(10)	The maximum transmission unit (MTU) value for this route in bytes. Can contain the following special value: *IFC The MTU of the interface that is associated with this route is used.
FAILURE_MESSAGE_ID	MSG_ID	CHAR(7) Nullable	The message ID from a failed cutover for the route. Contains the null value if the cutover action for this route 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 route has not failed.
PROCESSING_START_TIME	START_TIME	TIMESTAMP Nullable	Timestamp when cutover processing started for this route. Contains the null value if the cutover action for this route has not started.
PROCESSING_END_TIME	END_TIME	TIMESTAMP Nullable	Timestamp when cutover processing completed for this route. Contains the null value if the cutover action for this route has not ended or failed.

Example

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