Migration Transaction Screen

The application tracks all of the migration details that occur across the different environments and stores these details in the destination database. There are two ways in which you can view these details:

  • Migration Tool Migration Transactions page.

    This Migration Tool Migration Transactions page is accessed through the Migration Tool, through the Verify Migration Transactions action. For more information about the Migration Tool Migration Transactions page, see Verify the Migration.

  • Migration Transaction screen.

    The Migration Transaction screen is accessed through the application (System Administration > Migration Auditing > Migration Transaction). You can only view the Migration Transaction screens if you belong to a security group with at least VIEW rights to the screens.

Migration Transaction Summary Screen

The Migration Transaction summary screen displays a list of all the migrations and rollbacks that have occurred on the connected destination database. The records in the Migration Transaction summary screen are sorted by the last updated transaction (Last Updated column) in chronological descending order.

The columns within the Migration Transaction summary screen are:

Status
The status of the migration or export or rollback, as successful or partially successful.
Last Updated
The timestamp details of when the actual migration or rollback completed.
File Name
The migration or export filename.
Export User
The user who created the migration or export file.
Export OS User
The operating system user name. This is the operating system user who logged in when the migration or export was file was created.
Export Date
The timestamp details of when the migration or export file was created.
Export Purpose
The reason why the migration or export file was created.
Source DB
The database from which the data was migrated.

Migration Transaction Detail Screen

The Migration Transaction Detail screen displays the same, read-only record details as the Migration Transaction summary screen, but only for the record you selected.

Migration Details Screen

The Migration Details screen, displays a list of all the migrations or rollback operations that were performed for the selected record.

Here is a description of the columns within the Migration Details screen:

Migration ID
A system-generated unique ID that can be used to search for audit details in the application.
Last Updated
The timestamp details of when the actual migration or rollback completed.
Status
The current status of the migration or rollback as successful or partially successful.
Operation

The migration or rollback Insert, Update and Delete operation details. Here is an example:

<table name='JOB' key='JOB_ID'> <row op='update'> 
<col name='JOB_ID'>60094</col> <col name='JOB_NAME'>CFJOB13</col> 
<row op='lookup'> <col name='JOB_ID'>60094</col> 
<col name='JOB_NAME'>CFJOB13</col> </row> </row> </table> 
Operation Number
A system-generated, unique number for each migrated row.
Segment Number
During the migration process, each migration row is broken down into segments that are each assigned a unique segment number.

View Migration Transaction Details through WFM

  1. Select System Administration > Migration Auditing > Migration Transaction.

    The Migration Transaction summary screen is displayed.

  2. Click Edit next to the migration or rollback record to drill down to the migration or rollback details.

Modify Group Security Rights to the Migration Transactions Screen

  1. Select Maintenance > Security > Group Security > Security Group.
  2. In the Security groups field, select the group for which you want to modify security rights.
  3. In the Headings field, select Migration Auditing.
  4. Click Go.
  5. In the Security Manager screen, for each of the Migration Auditing screens (for example, Migration Auditing, Migration Details, and Migration Transaction), assign EDIT, VIEW, or NONE rights to the security group. For example, if you assign VIEW rights to all three Migration Transaction screen for the SYSTEM ADMINS group, then anyone belonging to the System Administrators group will be able view, but not edit, all three screens.
    Migration Auditing Screens SYSTEM ADMINS Security Permissions
    Migration Auditing VIEW
    Migration Details VIEW
    Migration Transaction VIEW
  6. Click Save.