Chapter 32. Data Consistency Utilities

In This Chapter

• The CHECK Utility

• The CHECK DATA Option

• The CHECK LOB Option

• The CHECK INDEX Option

• The REPAIR Utility

• The REPAIR DBD Option

• The REPAIR LOCATE Option

• The REPAIR SET Option

• REPAIR and Versions

• The REPORT Utility

• The DIAGNOSE Utility

Often, the consistency of data in a DB2 database must be monitored and controlled. In the scope of DB2 databases, consistency encompasses several things:

• The consistency of reference from index entries to corresponding table rows

• The consistency of reference from LOB entries to corresponding table rows

• The consistency of XML documents and the system-generated indexes associated with XML data

• The consistency of data values in referential ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial