Identifying Db2 data inconsistency problems
Data inconsistency problems occur for various reasons, including internal Db2 problems, I/O errors, or system problems.
About this task
Data inconsistency problems can occur as a result of referential integrity constraint violations. Referential integrity describes the condition where all references to data in pages are valid. Db2 provides referential integrity by enforcing referential constraints on the data. Referential integrity constraint violations do not cause abends because Db2 does not depend on referential constraints to operate. Referential constraint violations do, however, cause incorrect results in processing.
Data inconsistency problems fall into one or more of the following categories:
- Unavailable data
- Internal inconsistency
- Inconsistent page
- Inconsistent page set.
These conditions can exist singly or in combination. They are evidenced by various symptoms, and can be identified by a number of messages and codes. Discovering an inconsistency in user or Db2 system data can be difficult, depending upon the complexity of the problem.
Procedure
To identify Db2 data inconsistency problems: