Database Consistency menu
From the KM menu commands for the Database application instance, the Database Consistency menu accesses the following submenus and menu commands:
Menu or menu command | Description |
|---|---|
Menu of options that perform consistency checks on indexes, tables, and the database | |
Menu option that checks the internal consistency of data and index pages | |
Checkcatalog | Checks the database for tables or views with no columns, checks the validity of the column data types, and validates the last checkpoint log in syslogs |
Checkdb | Performs a checktable, that is, it checks the internal consistency of data and index pages, on all tables in the database |
Open Transaction | Displays information about the oldest active transaction |
Showcontig | Displays the fragmentation of a selected table or an index |