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 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.
