Online Database Inspection Tool

The new INSPECT command (or the db2Inspect API) allows you to inspect the architectural integrity of table spaces and tables while your database remains online. This is a significant improvement over the db2dart utility, which could only be used offline. The tool checks whether the structures of table objects and table spaces are valid. If done offline, such integrity checking of large databases could take a considerable amount of time, a period in which the database is unavailable for use. The inspect utility is integrated into the DB2 UDB engine and, as such, can take advantage of buffer pools and prefetchers for better performance.

Inspection of a whole database includes the processing of all table objects, ...

Get DB2® Version 8: The Official Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.