-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
IBM DB2 9.7 Advanced Administration Cookbook
This tool inspects structural and architectural correctness of databases and the objects within them. Since this tool reads the data directly from the disk, it is highly recommended to run it after all applications and users are disconnected (it is more desirable to effectively close the database). The main reason for this is that db2dart cannot read committed pages (dirty pages) from memory and the diagnostics will not be accurate.
The granularity of db2dart can be classified in levels, as database
, table space, and table. You can also dump and format table data, index data, and mark indexes as invalid to be eligible for rebuild. Also you can get information about table high watermarks and how to lower them.
In this recipe, we will verify the entire NAV database and use some analysis options, such as dump and formatting.
First, close the NAV database to have consistent data, before you run the db2dart...
Change the font size
Change margin width
Change background colour