MIGRATION_HOST_TABLE_ENTRY_INFO view

The MIGRATION_HOST_TABLE_ENTRY_INFO view returns information about host table entries 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_HTEINF. The schema is QSYS2.

Table 1. MIGRATION_HOST_TABLE_ENTRY_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 host table entry. ADD ON TARGET Add the host table entry on the target node. REMOVE FROM TARGET Remove the host table entry from the target node.
IP_ADDRESS	IP_ADDRESS	VARCHAR(45)	The IP address of the destination reached by this route.
HOST_NAME	HOST_NAME	VARCHAR(255)	The IP address that the host name is associated with.
TEXT_DESCRIPTION	TEXT	VARCHAR(50) Nullable	The text description that describes the host table entry. Contains the null value if there is no text description.
FAILURE_MESSAGE_ID	MSG_ID	CHAR(7) Nullable	The message ID from a failed cutover for the host table entry. Contains the null value if the cutover action for this host table entry 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 host table entry has not failed.
PROCESSING_START_TIME	START_TIME	TIMESTAMP Nullable	Timestamp when cutover processing started for this host table entry. Contains the null value if the cutover action for this host table entry has not started.
PROCESSING_END_TIME	END_TIME	TIMESTAMP Nullable	Timestamp when cutover processing completed for this host table entry. Contains the null value if the cutover action for this host table entry has not ended or failed.

Example

Review the list of host table entry changes that will be processed during the cutover stage.
```
SELECT * FROM QSYS2.MIGRATION_HOST_TABLE_ENTRY_INFO;
```