Validate Data Integrity (ttaad4233m000)

Use this session to validate database contents according to the data dictionary.

The session reads a range of tables for the specified company numbers, verifies their contents based on the selected validation options, and prints a report. The report contains information such as table names, the number of records, and any errors.

Note: 
  • This session only validates the contents of tables. To check the presence of a table or the proper existence of the data dictionary, run the Check Tables (ttaad4232m000) session first.
  • You can use the Referential Integrity (enhanced) field to check the validity of references This field is similar to the Check Validity of Reference field in the Reorganize Tables (ttaad4225m000) session, but has this added value:
    • Support of parallel processing.
    • Support of the Maximum errors table field to limit the number of reported errors per table.
    • More detailed report output. Reported reference issues include, for example, the index value of the records, so issues can be addressed conveniently.
    • Better performance.

Field Information

Domain Integrity

If this check box is selected, the domain constraints are verified. If the validated database contents violate the domain constraints that are defined in the data dictionary, errors are reported.

If this check box is cleared, the domain constraints are ignored.

Referential Integrity (enhanced)

If this check box is selected, the referential integrity constraints are verified. If the validated database contents violate the referential integrity constraints, errors are reported.

If this check box is cleared, the referential integrity constraints are ignored.

Referential integrity is about a relation between a child table (field) referring to a parent table (its primary key). From the Table Definitions (ttadv4520m000) > Table Definitions (ttadv4520m100) session, you can view the definition on child table field level in the Table Fields (ttadv4522m000) > Table Fields (ttadv4122s000) session.

To report a referential inconsistency for all affected child table field content, we recommend specifying a single parent table in the selection range of this session.

Note: 
  • If you use the Validate Data Integrity (ttaad4233m000) session, you specify the parent table. If you use the Reorganize Tables (ttaad4225m000) session, you specify the child table.
  • If a child field of a Combined Field is blank, not all reference violations may be reported in the Validate Data Integrity (ttaad4233m000) and Reorganize Tables (ttaad4225m000) sessions. See KB Article 2240519.
Check High Ascii

This check box is by default selected. An analyzation is done on the selected tables for high Ascii values. Errors are printed for each field that contains one or more high Ascii characters. You can switch between this option and the Check High ASCII by Locale option.

If the LN server does not run in Unicode mode, you can select this check box to predict whether switching to Unicode will lead to problems.

If the LN server runs in Unicode mode, you can clear this check box to allow high Ascii values in single byte fields.

Note: 

You can clear this check box in these cases:

  • The high_ascii_tolerance resource is set and has value 1.
  • The high_ascii_tolerance resource is not set and the LN server does not run in Unicode mode.

In all other situations, the check box is disabled and selected, so the session checks for high Ascii values.

Check High Ascii by Locale

This option validates if high ASCII characters in single byte strings are allowed for a selected (installation) locale. The results are listed on a separate report.

Maximum errors table

The maximum number of errors that will be reported for each table.

Type a value less than or equal to 0, if you do not want to specify a maximum number of errors.