{"id":1121,"date":"2016-04-16T13:14:54","date_gmt":"2016-04-16T13:14:54","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1121"},"modified":"2016-04-16T13:26:06","modified_gmt":"2016-04-16T13:26:06","slug":"how-to-use-the-teradata-checktable-utility","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=1121","title":{"rendered":"How to Use the Teradata CheckTable Utility"},"content":{"rendered":"<p>In this example I am using the Teradata Express. Logon on to the Teradata system, using Putty is just a preference.<\/p>\n<ol>\n<li>Start the cnsterm supervisor screen (or window): <strong>cnsterm 6<\/strong><\/li>\n<li>Start the Teradata CheckTable utility by entering: <strong>start checktable<\/strong>\n<ul>\n<li>The system will acknowledge that CheckTable has started, make note of the window that the utility starts in.<\/li>\n<\/ul>\n<\/li>\n<li>Exit the cnsterm supervisor screen by pressing ctrl -c: <strong>&lt; ctrl -c &gt;<\/strong><\/li>\n<li>Enter the window that the CheckTable utility was started in, the example below was window 1: <strong>cnsterm 1<\/strong><\/li>\n<li>Enter the command for checking the table: <strong>CHECK &lt; database &gt;.&lt; tablename&gt; AT LEVEL ONE;<\/strong>\n<ul>\n<li>In the example below, the PRODUCT table in the RETAIL database is being checked.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p style=\"padding-left: 60px;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/StartChecktable.jpg\" target=\"_blank\" rel=\"attachment wp-att-1126\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1126 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/StartChecktable.jpg\" alt=\"Start Checktable\" width=\"601\" height=\"756\" \/><\/a><\/p>\n<p style=\"padding-left: 60px;\">Displayed below is what the results from the CheckTable utility for a table.\u00a0 With this table, there are no issues.<\/p>\n<p style=\"padding-left: 60px;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableResults.jpg\" target=\"_blank\" rel=\"attachment wp-att-1125\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1125 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableResults.jpg\" alt=\"Checktable Results\" width=\"522\" height=\"386\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableResults.jpg 522w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableResults-300x222.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableResults-210x155.jpg 210w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><\/a><\/p>\n<p style=\"padding-left: 30px;\">6.\u00a0 To check all the tables in the entire database: <strong>CHECK &lt; database &gt; AT LEVEL ONE;<\/strong><\/p>\n<p style=\"padding-left: 60px;\">In the example below the CheckTable utility is check all three tables in the Manufacturing database.<\/p>\n<p style=\"padding-left: 60px;\">*** WARNING: best to check when the database is not being actively used ***<\/p>\n<p style=\"padding-left: 60px;\"><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableAtDatabaseLevel.jpg\" target=\"_blank\" rel=\"attachment wp-att-1122\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1122 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableAtDatabaseLevel.jpg\" alt=\"ChecktableAtDatabaseLevel\" width=\"505\" height=\"514\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableAtDatabaseLevel.jpg 505w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableAtDatabaseLevel-295x300.jpg 295w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableAtDatabaseLevel-206x210.jpg 206w\" sizes=\"(max-width: 505px) 100vw, 505px\" \/><\/a><\/p>\n<p style=\"padding-left: 60px;\">7.\u00a0 To properly quit the CheckTable utility, type &#8220;quit;&#8221; making sure that the semi-colon is on the end: <strong>quit;<\/strong><\/p>\n<p style=\"padding-left: 60px;\">8.\u00a0 Exit the cnsterm screen by pressing ctrl -c: <strong>&lt; ctrl -c &gt;<\/strong><\/p>\n<p style=\"padding-left: 60px;\">\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableQuit.jpg\" target=\"_blank\" rel=\"attachment wp-att-1124\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1124 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableQuit.jpg\" alt=\"Checktable Quit\" width=\"511\" height=\"129\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableQuit.jpg 511w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableQuit-300x76.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2016\/02\/ChecktableQuit-210x53.jpg 210w\" sizes=\"(max-width: 511px) 100vw, 511px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this example I am using the Teradata Express. Logon on to the Teradata system, using Putty is just a preference. Start the cnsterm supervisor screen (or window): cnsterm 6 &hellip; <a class=\"readmore\" href=\"http:\/\/www.theSQLReport.com\/?p=1121\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1126,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[72,69],"class_list":["post-1121","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teradata","tag-checktable","tag-cnsterm"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1121"}],"collection":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1121"}],"version-history":[{"count":9,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1121\/revisions"}],"predecessor-version":[{"id":1176,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1121\/revisions\/1176"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1126"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1121"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}