> For the complete documentation index, see [llms.txt](https://docs.tibero.com/prosyncmanager.en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tibero.com/prosyncmanager.en/prosync-manager-manual/integrity-check.md). # Integrity Check 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.

Item	Description
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.

{% hint style="info" %} **Note** These actions can be executed with a right-click after multiple selections of the table. The items that appear depend on the status of the selected Job, and the job is executed according to its status. {% endhint %} ## Create Check

Item	Description	Required Item
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.

Item	Description
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

Item	Description
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.` {% hint style="info" %} **Note** It is recommended using Microsoft's Excel program to open it, and described it based on that. {% endhint %} #### **How to open a CSV file** 1. Start the Excel Program 2. File > Import at the top of the menu 3. Select a CSV file and open the file 4. Select Delimited and UTF-8

5. Delimiters - Select Treat commas, spaces, and consecutive delimiters as one \\\ Text qualifiers - select '"' (double quotes)

6. Finish The above steps should be followed to open the file so that the users can check the data without any corruption or delimiters.

### --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.tibero.com/prosyncmanager.en/prosync-manager-manual/integrity-check.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.