Questions about CHECK_TABLE_CONSISTENCY

[SAPSupport]

Here are the questions about CHECK_TABLE_CONSISTENCY.

Q1: How can I check if the table consistency check (CHECK_TABLE_CONSISTENCY) has been executed?

Q2: If it has not been executed yet, how can I execute it manually?

Q3: What is the impact on the HANA system if I do not execute CHECK_TABLE_CONSISTENCY?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Here are the answers.

Ans 1:
There are different ways to check the execution history of CHECK_TABLE_CONSISTENCY. For example, you can check the monitoring view M_CONSISTENCY_CHECK_HISTORY or the column CHECK_TABLE_CONSISTENCY in M_CS_TABLES.
For more details, refer to SAP Note 2116157 - FAQ: SAP HANA Consistency Checks and Corruptions, specifically section "26. Where can I find the output of CHECK_TABLE_CONSISTENCY?"

Ans 2:
You can execute the table consistency check manually using the following commands:

• General: CALL CHECK_TABLE_CONSISTENCY('CHECK', NULL, NULL);
• Schema level: CALL CHECK_TABLE_CONSISTENCY('CHECK', '<SCHEMA_NAME>', NULL);
• Table level: CALL CHECK_TABLE_CONSISTENCY('CHECK', '<SCHEMA_NAME>', '<TABLE_NAME>');

For more details, refer to SAP Note 2116157 - FAQ: SAP HANA Consistency Checks and Corruptions, specifically section "6. What are the minimum recommendations in terms of SAP HANA consistency checks?"

Ans 3:
Regular consistency checks are required to detect hidden corruptions as early as possible.
For more details, refer to SAP Note 2116157 - FAQ: SAP HANA Consistency Checks and Corruptions, specifically section "4. Why do I need consistency checks?"