MIGRATED_LIBRARY view

Edit online

The MIGRATED_LIBRARY view returns a list of library-based objects that have been successfully migrated to the copy node by IBM® i Migrate While Active.

The objects returned by this view were modified on the source node after the initial system migration and have been successfully migrated to the copy node. It includes library-based objects that have been migrated using either the Db2® Mirror method of synchronization or the save and restore method of synchronization. Any migrated library-based object will have a single row returned by the view. If an object is migrated multiple times, the SUCCESSFUL_MIGRATION_COUNT column will reflect the number of times it has been migrated.

When an object requires migration, it is included in the QSYS2.LIBRARY_MIGRATION_LIST view. After the first successful migration for an object, a row for the object is returned in this view.

Authorization: The caller must have *ALLOBJ special authority.

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

Table 1. MIGRATED_LIBRARY 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) 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
INITIAL_TRACKING_TIME TRACK_TIME TIMESTAMP The timestamp when the object was added to the migration list.
MIGRATION_START_TIME START_TIME TIMESTAMP The timestamp of the start of the most recent successful migration.
MIGRATION_END_TIME END_TIME TIMESTAMP The timestamp of the end of the most recent successful migration.
SUCCESSFUL_MIGRATION_COUNT MIG_COUNT INTEGER The number of times the object has been successfully migrated to the copy node during this system migration.
OBJECT_SIZE OBJ_SIZE BIGINT
Nullable
 The approximate size of the object, in bytes, for the most recent migration of the object.

Contains the null value if the size of the object is not available.

Example

  • Review objects in TOYSTORE that completed migration within the last hour.
    SELECT * FROM QSYS2.MIGRATED_LIBRARY  
  WHERE LIBRARY_NAME = 'TOYSTORE' AND 
        MIGRATION_END_TIME > CURRENT TIMESTAMP - 1 HOUR
  ORDER BY MIGRATION_END_TIME DESC;