Archives of the TeradataForum

Message Posted: Wed, 28 Oct 2003 @ 22:47:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Nazy,

Here is what the check table does..

CheckTable checks for inconsistencies among internal data structures, such as table headers, row identifiers and secondary indexes. In more details see below.

Check table can perform the following four options.

* Compares primary and fallback copies of data and hashed secondary-index subtables.

* Compares index subtables to the corresponding data subtables.

* Compares table headers across AMPs and compares table headers to information in the Data Dictionary.

* Validates that the set of tables found on all AMPs matches the set found in the Data Dictionary. This check is done only if a check of database DBC or ALL TABLES is specified.

Although Check Table identifies and isolates data inconsistencies and corruption, it cannot repair inconsistencies or data corruption.

Regards

Ivan Harizanov

	<Prev	Next>		<<First	<Prev	Next>	Last>>