The Referential Integrity check process tests all relationships registered in SX9, ensuring that the information saved in the base is respecting these relationships.
Thread integrity check
Thread is a small program that works as a subsystem independent of a larger program, performing a specific task. A multi-threaded program can run faster than a monolithic program because multiple tasks can be run concurrently, allowing you to share System resources.
To gain performance in integrity check processing, you must configure the MV_INTTHR parameter that defines the number of threads that the System must execute at the same time.
Example of use:
Consider a database with 300 records performing the integrity check and the MV_INTTHR parameter filled with 3 (three), configured to run three threads simultaneously. See the diagram illustrating how the verification will be processed.
Procedures
To access the verification process:
1. Select Verification and after reading the description of the routine, click OK.
2. Select the companies that will have the verified base and click OK.
When the process starts, a progress bar will be displayed, indicating which table your content is parsing.
At the end of the verification, if there is no divergence, the process will present a message stating that the basis is complete.
3. Click OK.
If there are differences, the program will display a report indicating them.
In the Synthetic option, the report will indicate how many occurrences are not ok for each relationship.
In the Analytic option, the report will show all occurrences that violate the registered relationship.
Previous procedures for database security with Referential Integrity when applying compatibility programs.
ATTENTION
The compatibility program must run withReferential Integrity disabled*.
The routine creates several procedures to test the integrity and the database used must be approved to use them.
A professional qualified as Database Administrator (DBA) or equivalent must adopt the procedure!
The incorrect activation of the Referential Integrity may drastically change the relationship of tables in the database. Therefore, before enabling it, read the following instructions carefully:
i. In Configurator (SIGACFG), check whether the company uses Referential Integrity by selecting the option Integrity/Verification (APCFG60A). ii. If the Referential Integrity is not active, all companies and branches registered in the system are displayed in a new window. None of them is selected. In this case, AND ONLY IN THIS CASE, no other procedure is necessary to activate or deactivate the integrity. Just finish the check and run the compatibility program according to the instructions. iii. If the Referential Integrity is active in all companies and branches, a message is displayed in the window Verification of relationship between tables. Confirm the message to finish the verification, or; iv. If the Referential Integrity is active in one or more companies, but not in all of them, a new window displays all companies and branches registered in the system. Only the ones with integrity enabled are selected. Write down the companies and/or branches with integrity enabled and save it for later reactivation (or contact the Help Desk Framework for information on the file containing this information). v. In the situations described in items iii or iv, AND ONLY IN THESE CASES, you must disable such integrity by selecting the option Integrity/Disable (APCFG60D). vi. When the Referential Integrity is disabled, run the compatibility program according to instructions. 7. After running the compatibility program, the Referential Integrity must be re-enabled IF AND ONLY IF it has been disabled through the option Integrity/Enable (APCFG60). For that matter, have on hand the companies and/or branches which had the integrity enabled, select them again and confirm the activation.
Contact the Help Desk Framework if you have any questions! |
|---|
