The Run Consistency Checks tab

The Run Consistency Checks tab on the Server Tools Consistency Checks Info screen manages the process of running database consistency check batch processing. From this screen, you can:

Start, stop, pause, restart, or cancel consistency check batch processing.
Set the tables or table groups on which to run the consistency checks.
Set the number of workers to use in the batch processing.
Set the type of consistency checks to run.
Review the results of each consistency check batch processing in tabular format.

The Run Consistency Check tab contains the following items.

Item	Action
Download all selected	Click to download the consistency check results for all selected consistency check runs in the results table.
Delete	Click to delete the results of prior consistency check runs for those rows with a check mark in the results table.
Refresh	Click to update the information on the screen while processing is active.
Run Consistency Checks	Click to submit a batch processing job to perform one or more database consistency checks. This action executes the Database Consistency Check batch process. This button is not available if the Database Consistency Check work queue is not active,
Pause/Resume Consistency Checks	Click to pause a currently executing batch processing job. During a pause in processing, PolicyCenter changes the button label to Resume. Clicking the button resumes processing execution. If this button is not visible, click the Refresh button.
Cancel Consistency Checks	Click to cancel all currently executing batch processes. PolicyCenter displays this button only if there are currently executing consistency checks. If there are a large number of checks currently executing, PolicyCenter displays a progress bar for the cancellation process. Understand that the cancel button changes the state of the executing checks overall to canceled. However, as PolicyCenter cancels each consistency check individually, the progress bar can continue for some time if there are a large number of checks to cancel.
All tables Specify tables Specify table groups	Click to select All tables (default) to run consistency check against all database tables. If you select Specify tables, PolicyCenter opens a table picker from which you can select the database tables against which the consistency checks run. You must select at least one table. If you select Specify table groups, PolicyCenter opens a table groups picker from which you can select the table groups against which the consistency checks run. You must select at least table group.
Change	Click to change the number of workers used to execute the consistency check. Enter a positive integer value. If you change the number of workers in an active work queue, PolicyCenter stops the existing work queue and restarts it with the new number of workers. This button is not available if the Database Consistency Check work queue is not active,
Check all types?	Click to select Specify Types to see the list of available check types from which you can make a selection of

The consistency checks results table

After completing a consistency check, the results table columns have the following meanings.

Column	Description
Download	Click the Download icon to download a ConsistencyCheck`Rundate`.zip file that contains the set of database reports generated by this consistency check run.
Download Errors	Click the Download Errors icon to download a ConsistencyCheckRunErrorsOnly`RunDate`.zip file that contains the consistency check log file and stack trace. PolicyCenter displays this column only if there are SQL errors in the database consistency check.
View	Click the View icon to open a pop-up from which you can view the same reports contained in the ConsistencyCheck`Rundate`.zip file, after you supply your user credentials. PolicyCenter displays this column in test and development mode only. The column is not visible in production mode.
Delete	Click the Delete icon to remove a consistency check row from the table.
Rerun	Rerun a consistency check that has a SQL error. PolicyCenter displays this button only if there are SQL errors in the database consistency check.
Description	List of tables against which the consistency checks ran.
With Errors	Number of errors encountered by the consistency checks run.
Total Checks	Total number of consistency checks that ran.
Not started	Number of consistency checks that have not yet started in the current consistency checks run. Click the Refresh button to update this data during a currently executing check run.
In progress	Number of actively executing consistency checks at any given moment.
Finished	Number of consistency checks that completed in this run.
Workers	Number of workers that PolicyCenter used in running the consistency check process.
Start time	Time at which this set of consistency checks started.
End time	Time at which this set of consistency checks ended.
Duration	Length of time that this set of consistency checks took to run.
Version	Database version, listing (in order): Application major version Application minor version Platform major version Platform minor version Data model version
ID	Identifier (ID) of the stored results of this consistency check run.

If the consistency checks results table lists multiple check runs, use the check box next to a table row to select a consistency check run for further action.