Skip to Main Content
Return to Navigation

Viewing Compare Reports

Use the Compare reports page (PTADSCMPRPT2) to review the reports and update the Upgrade actions.

The compare data is stored in two tables, PSCOMPSESSION stores the information about the compare session and PSCOMPOBJDIFF stores the comparison data for each particular instance.

Image: Compare Report page

This example illustrates the fields and controls on the Compare Report page. You can find definitions for the fields and controls later on this page.

Compare Report page

The Compare Report page displays the current project state, the last datetime that a compare was run and a summary of the differences found between the source and target.

Project Navigator Section

The Project Navigator section displays the data migration project content in a tree structure for each of the records in the record hierarchy of the data set definition.

When you click on one of the nodes in the tree, the corresponding report information is displayed at the bottom of the page in a Compare Report section.

Filter By

The Filter By section allows you to select the Data Set Name and record to display in the Compare Report section.

Compare Reports

Use the Compare Report section to review the differences and update or change the Upgrade action.

The compare reports are displayed in a grid. You can adjust the column width like any other grid.

Image: Compare Report Section 1

This example illustrates the fields and controls on the left hand side of the Compare Report. You can find definitions for the fields and controls later on this page.

Compare Report Section 1

Image: Compare Report Section 2

This example illustrates the fields and controls on the right hand side of the Compare Report. You can find definitions for the fields and controls later on this page.

Compare Report Section 2

The report has 9 columns.

Data Set Name

The name of the data set definition.

Data Set Instance

Specifies the specific row of data in the data migration project.

Record Name

The name of the record for the data instance.

Field Name

The name of the field.

Source Value

The value on the source system. The source is the system that initiated the compare.

Target Value

The value on the target system.

Action

Possible actions are:

  • Copy

  • Delete

Upgrade

The value depends on the value of the PTMERGESTATUS of the compare table. This check box is editable. When you change the selection (clear or select) on the report, it is saved to the database.

Done

The value depends on the value of the PTMERGESTATUS of the compare table. This check box is partially editable, it can be change from checked to unchecked, but not from unchecked to checked. When you change the selection (clear or select) on the report, it is saved to the database.

This table describes the meaning of the various combinations of the Upgrade and Done flags:

Upgrade

Done

Meaning

Unchecked

Unchecked

The row is not to be upgraded and upgrade action (is or is not, as the case may be) completed.

 

Unchecked

Checked

The row is not to be upgraded and upgrade completed.

Checked

Unchecked

The row is to be upgraded and upgrade not completed

Checked

Checked

The row is already upgraded. A second run of copy will ignore this row.