MIGRATION_MANAGER_INFO view

Edit online

The MIGRATION_MANAGER_INFO view returns information about the IBM® i Migrate While Active environment.

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/MIG_MANAGE.
  • For the authority needed to use this view, see Db2® Mirror services authorization.

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

Table 1. MIGRATION_MANAGER_INFO view
Column Name System Column Name Data Type Description
ENTRY_TYPE ENTRY_TYPE VARCHAR(17) The type of migration information.
IFS RESTORE
This entry returns information related to integrated file system object synchronization for migration.
MIGRATION MANAGER
This entry returns information related to the Migration Manager.
OBJECT MIRROR
This entry returns information related to objects within libraries that use the Db2 Mirror method of synchronization for migration.
OBJECT RESTORE
This entry returns information related to objects within libraries that use the save and restore method of synchronization for migration.
SOURCE_NODE_STATE SRC_STATE VARCHAR(14)
Nullable
The state of tracking changes on the source node.
ACTIVE
Changes to objects on the source node are being tracked.
NOT ACTIVE
Changes to objects on the source node are not being tracked.
NOT CONFIGURED
The product is not installed or the configuration of IBM i Migrate While Active is not complete.

Contains the null value if ENTRY_TYPE is not MIGRATION MANAGER.
COPY_NODE_STATE COPY_STATE VARCHAR(14)
Nullable
The state of Start of changemigration or change tracking onEnd of change the target node.
MIGRATING
The operating system, system data, and user data on the source node is being migrated to the target node.
ACTIVE
Start of changeEither changes to objects on the target node are being tracked or theEnd of change target node is the primary node, and configuration information relating to IBM i Migrate While Active remains on this node.
Start of changeNOT ACTIVEEnd of change
Start of changeChanges to objects on the target node are not being tracked.End of change
NOT CONFIGURED
The product is not installed.

Contains the null value if ENTRY_TYPE is not MIGRATION MANAGER.
MIGRATION_STAGE MIG_STAGE VARCHAR(20)
Nullable
The current migration stage.
SYSTEM MIGRATION
Encompasses all migration phases required to set up and migrate the operating system, licensed program products, security, and user data from the source node to the target node.
DATA SYNCHRONIZATION
Encompasses all migration phases required to perform object synchronization between the nodes for objects that have changed since the SYSTEM MIGRATION stage completed.
CUTOVER
Encompasses the migration phases required to perform a primary node role swap from the source node to the target node after the data synchronization has completed and before the target node can be used.

Contains the null value if IBM i Migrate While Active is not installed or the configuration of IBM i Migrate While Active is not complete.
MIGRATION_PHASE MIG_PHASE Start of changeVARCHAR(50)End of change
Nullable

The migration phase for the Migration Manager.

The following values apply when MIGRATION_STAGE has a value of SYSTEM MIGRATION:
SETUP
Initial environment configuration is being performed to set up IBM i Migrate While Active.
FINAL SETUP
Final environment configuration is being performed to complete the system migration stage.
Start of changeSETUP COMPLETEEnd of change
Start of changeFinal environment configuration is complete. The Migration Manager is ready to begin the data synchronization stage.End of change
The following values apply when MIGRATION_STAGE has a value of DATA SYNCHRONIZATION:
SYNCHRONIZING
Changes to objects on the source node are being synchronized to the target node.
Start of changeIMMEDIATE SYNCHRONIZATIONEnd of change
Start of changeImmediate synchronization is in progress. Changes to Db2 Mirror replication-eligible objects are actively synchronized from the source node to the target node.End of change
PAUSED
Synchronization of objects has stopped. Changes to objects on the source node are being tracked on the source node.
FINAL SYNCHRONIZATION
Final synchronization is being performed to complete the migration of objects during the data synchronization stage.
The following values apply when MIGRATION_STAGE has a value of CUTOVER:
SYNCHRONIZATION COMPLETE
The Start of changedata synchronizationEnd of change stage is complete. The Migration Manager is ready to perform the primary node role swap.
SWAPPING
A primary node role swap is being performed.

Contains the null value if MIGRATION_STAGE is null.
PENDING_MIGRATION_PHASE PENDING Start of changeVARCHAR(50)End of change
Nullable
The migration phase the Migration Manager is working to transition into.
FINAL SETUP
Final environment configuration to complete migration setup is pending.
FINAL SYNCHRONIZATION
Final synchronization to complete object synchronization is pending.
Start of changeIMMEDIATE SYNCHRONIZATIONEnd of change
Start of changeStart of immediate synchronization of objects is pending.End of change
PAUSED
Pausing object synchronization is pending.
Start of changeSETUP COMPLETEEnd of change
Start of changeCompletion of final environment configuration is pending.End of change
SYNCHRONIZING
Start of object synchronization is pending.

Contains the null value if no migration phase is pending or if ENTRY_TYPE is not MIGRATION MANAGER.
MIGRATION_PHASE_DETAIL MIG_DETAIL VARCHAR(24)
Nullable
Additional information about the current migration phase.
ACTIVE
Processing is actively being performed by the Migration Manager.
Start of changeCANCEL PENDINGEnd of change
Start of changeThe Migration Manager is actively performing any processing required to cancel the transition to the pending migration phase.End of change
COMPLETED
Processing being performed by the Migration Manager has successfully completed.
ERROR
An error was encountered by the Migration Manager during processing.
INACTIVE
No processing is being performed.
Start of changePREPARING FOR PENDINGEnd of change
Start of changeProcessing is actively being performed by the Migration Manager in preparation for transitioning into the pending migration phase.End of change
PREPARING FOR RESTRICTED
Processing is actively being performed by the Migration Manager in preparation for putting the source node into a restricted state.
Start of changeREADY FOR PENDINGEnd of change
Start of changePreparations before transitioning into the pending migration phase by the Migration Manager has successfully completed.End of change
READY FOR RESTRICTED
Preparations before putting the source node into a restricted state by the Migration Manager has successfully completed.

Contains the null value if MIGRATION_STAGE is null.
MIGRATION_DETAIL_INFO MIG_INFO INTEGER
Nullable

Additional information about the processing defined by MIGRATION_PHASE_DETAIL.

Contains the null value if no additional information is available.
MIGRATION_DETAIL_INFO_TEXT MIG_TEXT VARCHAR(1024)
Nullable

Descriptive text corresponding to MIGRATION_DETAIL_INFO.

Contains the null value if no additional information is available.
MIGRATION_INTERVAL_COUNT MIG_INT INTEGER
Nullable

The number of times jobs have been started for this migration phase.

Start of changeContains the null value if MIGRATION_STAGE is SYSTEM MIGRATION.End of change
QUALIFIED_JOB_NAME JOB_NAME VARCHAR(28)
Nullable

The qualified job name of the active job performing the current migration phase, or the most recent job for this migration phase.

Start of changeContains the null value if MIGRATION_STAGE is SYSTEM MIGRATION.End of change
SOURCE_NODE SRC_NODE VARCHAR(8)
Nullable

The name of the partition designated as the source node for this migration.

Contains the null value if MIGRATION_STAGE is null or if ENTRY_TYPE is not MIGRATION MANAGER.
COPY_NODE COPY_NODE VARCHAR(8)
Nullable

The name of the partition designated as the target node for this migration.

Contains the null value if MIGRATION_STAGE is null or if ENTRY_TYPE is not MIGRATION MANAGER.
PRIMARY_NODE PRIMARY VARCHAR(8)
Nullable

The name of the partition currently designated as the primary node.

Contains the null value if MIGRATION_STAGE is null or if ENTRY_TYPE is not MIGRATION MANAGER.
Start of changeMIGRATION_SOURCE_NODEEnd of change Start of changeINITIALEnd of change Start of changeVARCHAR(3)
Nullable
End of change		 Start of change
Indicates whether this node is the initial source node for the migration pair.
NO
This node is not the initial source node.
YES
This node is the initial source node.

Contains the null value if MIGRATION_STAGE is null or if ENTRY_TYPE is not MIGRATION MANAGER.

End of change

Example

  • Review all the information about the Migrate While Active environment.
    SELECT * FROM QSYS2.MIGRATION_MANAGER_INFO;