The DBChecker utility generates and executes SQL commands for database verification. This verification procedure generates a result log file complog.txt and a suggested corrective action list in the log files recreate.txt and recreate_user.txt.
complog.txt — Contains all database problems the DBChecker Utility has found during a database check. The software creates this file on completion of a database check. When detecting a data integrity problem, the DBChecker Utility writes to the complog.txt file the SQL command or commands that have identified the problem. The complog.txt file can also include the Special Operations section that contains the SQL commands that identified the problem, but for which there is no pre-defined automatic solution. Usually, the issues identified in the Special Operations section are related to the engineering data inconsistencies that need to be resolved through the user operations in itself. If no problems are found, the file only contains the time of the session, the database platform information, and the database name. If you run another database check, the software overwrites the records that appear in the file.
recreate.txt — Contains all fix suggestions for the database problems found during a database check. The fix suggestions are represented as SQL commands. The software creates this file on completion of a database check. If the software does not find any problems in the database, the recreate.txt file only contains the time of the session and the database platform information. If you run another database check, the software overwrites the records that appear in the file.
recreate_user.txt — Contains selected specific fix suggestions for the problems that you select in the Check Results dialog box. The fix suggestions are represented as SQL commands. The Check Results dialog box only opens if the software finds a database problem. The software creates this file after you click Fix or Create Log in the Check Results dialog box. If you click Fix to fix the database problems on the fly, some of the fixes that you selected might not be implemented successfully. The software records information of such fixes in the recreate_user.txt file. If you previously created the recreate_user.txt file, the software appends new log data to the existing data. The records in the log file are separated by date and time of log data creation. You can clear the log file manually.