LIBRARY_MIGRATION_LIST view

Edit online

The LIBRARY_MIGRATION_LIST view returns information from the library tracking list (LTL) and object tracking list (OTL).

Each row in the list represents a single object that needs to be migrated to the copy node using IBM® i Migrate While Active. These are objects that have been modified on the source node since the initial system migration. Multiple changes to an object will generally be reflected in a single entry. When an object is created, deleted, or renamed, there may be more than one entry in the list for the same object.

When an object completes migration, it is no longer visible in this view. Use the QSYS2.MIGRATED_LIBRARY view to see the list of objects that have been successfully migrated.

Authorization: The caller must have *ALLOBJ special authority.

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

Table 1. LIBRARY_MIGRATION_LIST view
Column Name	System Column Name	Data Type	Description
LIBRARY_NAME	LIB_NAME	VARCHAR(10)	The library name that contains OBJECT_NAME.
OBJECT_NAME	OBJ_NAME	VARCHAR(128)	The name of the object.
OBJECT_TYPE	OBJ_TYPE	VARCHAR(8)	The object type. In addition to system object types, the following additional values can exist in the list. ENVVAR Environment variable FCNUSG Function usage SECATR Security attribute SPLF Spooled file *SYSVAL System value
TRACKING_STATE	TRACKING	VARCHAR(10)	The tracking state for the object. INELIGIBLE The object is not supported by Migrate While Active. The object must be manually updated on the copy node. PREPARING Migrate While Active has recognized that this object has changed and needs to be migrated to the copy node. READY Migrate While Active has recognized that this object has changed and is ready to migrate this object to the copy node. FAILED An attempt to migrate this object failed. The FAILURE_MESSAGE and FAILURE_JOB_NAME columns provide additional information. This object is ready for another migration attempt. MIGRATING The object is currently migrating to the copy node. If the migration for the object is not successful, the object's TRACKING_STATE is set to FAILED. DEFERRED The object will not be migrated until the FINAL action is requested while in the data synchronization stage.
INITIAL_TRACKING_TIME	TRACK_TIME	TIMESTAMP	The timestamp when the object was added to the migration list.
OBJECT_SIZE	OBJ_SIZE	BIGINT Nullable	The approximate size of the object, in bytes. Contains the null value if the size of the object is not available.
MIGRATION_START_TIME	START_TIME	TIMESTAMP Nullable	The timestamp for the start of the current migration. Contains the null value if TRACKING_STATE is not MIGRATING.
FAILURE_JOB_NAME	FAIL_JOB	VARCHAR(28) Nullable	If migration for the object has been attempted and failed, the qualified job name for the most recent failed migration. Contains the null value if TRACKING_STATE is not FAILED.
FAILURE_MESSAGE	FAIL_MSG	CHAR(7) Nullable	If migration for the object has been attempted and failed, the failure message ID for the most recent failed migration. Contains the null value if TRACKING_STATE is not FAILED.
TRACKING_LIST	TRACK_LIST	VARCHAR(21)	OBJECT TRACKING LIST This object is recorded in the Db2® Mirror object tracking list (OTL). LIBRARY TRACKING LIST This object is recorded in the library tracking list (LTL).

Example

Review the list of files that need to be migrated to the copy node.

SELECT LIBRARY_NAME, OBJECT_NAME, OBJECT_SIZE 
  FROM QSYS2.LIBRARY_MIGRATION_LIST
  WHERE TRACKING_STATE <> 'MIGRATING'
  ORDER BY LIBRARY_NAME, OBJECT_NAME;