Integrity Check
This section introduces the Integrity Check page, which is related to checking the consistency of synchronized data.
The users can perform consistency checks on synchronized data.
Integrity Check
Integrity Check refers to ProSync's consistency check.
It checks whether data consistency matches for specific tables in the source and target DBs being synchronized, and if it does not, the users can check or correct the result of the consistency check.
Integrity Check area
Setting Create Check and Thread
The users can create a job to check for consistency, and set the thread count to be used by the job.
Filtering area
The users can search among the created jobs by filtering by specific instance, check status, and check name.
The left side shows the items used for filtering, which can be removed from filtering via the x button to the right of each filter tag or reset with the Filtering Reset button. These items can be specified via the filter button on the right.
The numbers to the right of the filtering item indicate the number of jobs of that status.
Refresh and delete details
Refresh: Updates the status as the job progresses.
Delete details: Checks and deletes the details of a registered job.
Integrity Check Table
This is the table where the users can see the list with all filtering applied.
Select the desired entry in the table for the Job's behavior, or for deleting and editing.
Stream Name
The name of the stream to perform the consistency check.
Instance Name
The name of the instance to perform the consistency check.
Check Name
The name of the consistency check.
Status
The status of the consistency check.
Source
The table information of the source DB to perform the consistency check.
Target
The table information of the target DB to perform the consistency check.
Check Type
Type of the type to perform the consistency check.
Check Option
Option to perform the consistency check.
Cycle
Indicates whether to schedule.
Monthly: Runs the job at the specified time every month.
Weekly: Runs the job at the specified time every week.
Daily: Runs the job at the specified time every day.
None: This is a one-time job that is not scheduled.
Start Time
The start time of the consistency check.
Update Time
The last time the Status of the consistency check was changed.
SQL Download
This button downloads the correction SQL file if there is a consistency mismatch.The generated SQL file has the same name as verify_[ID]_[Check Name].sql, and the contents of the sql file are written based on the Source Table and reflected in the Target Table when reflected.
Correction
If there is a mismatch, this button reflects the correction sql file to the DB.
Re-Check
This button reexecutes the consistency check.
Cancel
This button cancels the consistency check or correction.
Create Check
Schedule Setting
The users can set the schedule of the integrity check.
Integrity Check Reservation: Specify whether to use scheduling.
Start Time: Specify the time when the integrity check is performed.
Cycle Settings: Specify whether to perform the integrity check repeatedly. The users can set the cycle in Monthly / Weekly / Daily units.
N
Stream Name
Select a stream to perform the consistency check.
Y
Check Name
Enter a name for the consistency check except Korean characters.
Y
Source Schema
Select the schema of the source DB to perform the consistency check.If the users select All, a job is created for the entire schema of the synchronization table.
Y
Source Table
Select the table of the source DB to perform the consistency check.If the users select All, a job is created for the entire table of the synchronization table.
Y
Check Type
Select the type of consistency check to be performed.
All column: Compares all columns to check consistency.
Key column: Compares only the primary key to check consistency.
Y
Check Option
Check the consistency check with Flashback Query as an option. If the users disable this option, the check is performed at the current time, and if synchronization is in progress, the consistency is not guaranteed.If the users select this option and the check cannot be performed because there is no snapshot at that time, the check is automatically disabled and the check is performed at the current time.
N
Where Clause
Enter a where clause to be used for the consistency check. The users do not need to enter a 'WHERE' condition, only the conditional statement the users want to check, and the users can specify the range to check for a specific column, etc.
N
Integrity Check Filtering
When searching the Integrity Check table, the users can utilize these filters to perform more sophisticated searches.
Replication Diagram area
The users can see a list of Streams - Instances that belong to the Diagram specified in the Diagram Filter in the header of the page.
Select the Instances the users want to select/clear by the filtering criteria. Select Stream if the users want to select/clear all instances in a Stream, or Diagram if the users want to select/clear all instances in the current Diagram.
Integrity Check Status area
All of the status types available on the Integrity Check page.
Checking Ready
The job is waiting to be checked.
Checking
The job is in the checking state.
Match
The job has finished checking and the match is a match.
Mismatch
The job has finished checking and the match is a mismatch.
Correcting Ready
The job is waiting to be corrected.
Correcting
The job is in the correcting state.
Correction Complete
The job is in the correction state. Correction Complete means that the correction of the job is complete.
Error
An error occurred during the inspection/correction of the job.
Click the Info icon of the status to check the detailed message.
Cancel
The job was canceled during the inspection/correction.
Integrity Result Report
This feature allows the users to check the result of the Integrity Check execution. The users can check and download the Result Report item when the users right-click the mouse by selecting multiple jobs to check.
Integrity Result Report
Integrity Job Tab
The name of each job for which the users want to view the Result Report.
Result CSV download
The users can download each Result Report as a csv file and manage it.
It has a name like
Integrity_Report_[Job Name].csv.
Result Report table
Check Start Time
The time when the check of the job started.
Check End Time
The time when the check of the job ended.
Check Error Msg
The message checked when an error occurred during the check of the job.
Mismatch Rows
The total number of mismatched rows when the job was in Mismatch status.
Insert Rows
The number of rows corresponding to Insert during the correction operation.
Update Rows
The number of rows corresponding to Update during the correction operation.
Delete Rows
The number of rows corresponding to Delete in a correction operation.
Correction Start Time
The time when the correction of the job started.
Correction End Time
The time when the correction of the job ended.
Correction Error Msg
The message checked when an error occurred during the correction of the job.
Integrity Result Report Download
The users can download and manage the Result Report, which has a name like Integrity_Report_[Job Name].csv.
How to open a CSV file
Start the Excel Program
File > Import at the top of the menu
Select a CSV file and open the file
Select Delimited and UTF-8
Delimiters - Select Treat commas, spaces, and consecutive delimiters as one \ Text qualifiers - select '"' (double quotes)
Finish
The above steps should be followed to open the file so that the users can check the data without any corruption or delimiters.
Last updated