Special considerations for suspected page inconsistencies

During SQL processing of, for example, an INSERT, UPDATE, or DELETE statement, Db2 makes data consistency checks to verify that the processing did not produce any inconsistent data.

The number of checks that Db2 makes depends on whether the global trace is active. If the global trace is not active, only a subset of the data inconsistency checks is made. If the global trace is active, all the checks are made.

During normal operation, the subset of checks is sufficient. If you suspect data inconsistency problems are the result of an inconsistent page, activating the global trace is yet another method that can be used to help verify whether there is inconsistent data.

During utility operations, and operations, such as RESTART, that apply log records to a page, Db2 performs all the data inconsistency checks, whether the global trace is activated.