Table Integrity Report Window
The Table Integrity Report window appears when you select the Integrity option from the Resolver Reports Menu window. This window allows you to define a report that compares a table in the local database against the same table in a different database.
You specify the criteria for the comparison based on transaction begin and end time, and if desired, a CDDS value to designate a particular horizontal partition. You can also designate the sort order of the report by replicated column or transaction time.
The Table Integrity Report window has the following items:
Compare contents of table
Specifies the replicated table for the first and second database that you want to compare.
for owner
Identifies the owner of the table. If only one user owns a table by that name, this field is automatically filled in. For tables with multiple owners, a pop-up table appears, which lets you select the appropriate owner.
in Consistent Distributed Data Set (optional)
(Optional) Identifies the value of the CDDS number to be reported. If the table is not horizontally partitioned, this field is automatically filled in with the CDDS number under which the table is registered.
For horizontally partitioned tables, enter a CDDS number from the CDDS lookup table. You can use ListChoices to view a list of acceptable values.
in Database Number 1
Identifies the number of the local database. This field is automatically filled in.
and Database Number 2
Identifies the number of the other database that you want to compare with the local database.
Begin
(Optional) Specifies the beginning of a date range in standard Ingres date and time format.
End
(Optional) Specifies the end of a date range in standard Ingres date and time format.
Column Name
Displays the names of all registered columns for the specified table. A trans_time column also appears representing the transaction time.
Order
Lets you display rows in a specific order. Enter values (in numerical sequence starting with 1) beside each column name.
Go
Executes the report.
