CheckTable checks certain aspects of tables regardless of the level of checking that is specified. These general checks include things like checking the table headers, checking for obsolete subtables, and checking the Data Dictionary.
| Check Type | Description |
|---|---|
| Data Dictionary | Two special checks involve the Data Dictionary:
These special checks are only performed when the user issues a CHECK DBC or CHECK ALL TABLES command and the system has logons disabled and is quiescent. |
| Table headers | Compares table header components on all AMPs with the table header from the AMP with the lowest virtual processor (vproc) number of all online AMPs. |
| Table structure | Compares the table structure version stored in DBC.TVM to the table structure version stored in the header. |
| Obsolete subtables | checks for extraneous subtables of a given table. |
| Parent/Child count | Verifies if the ParentCount and ChildCount in DBC.TVM match the ParentCount and ChildCount in the table header. |
| Table Map Info | Verifies that the map information stored in DBC.TVM and DBC.MAPS match the map information stored in table headers. |
| Pending operations | Checks the table header to determine if any table has any pending operations. This check works for global temporary tables as well as base tables. |