{"id":1090,"date":"2016-03-01T15:28:55","date_gmt":"2016-03-01T15:28:55","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1090"},"modified":"2016-03-01T15:30:40","modified_gmt":"2016-03-01T15:30:40","slug":"how-to-run-showblocks-with-the-ferret-utility","status":"publish","type":"post","link":"http:\/\/www.theSQLReport.com\/?p=1090","title":{"rendered":"How to run Showblocks with the Ferret Utility"},"content":{"rendered":"

Teradata support asked me for information from the “showblocks” command for a problem table in the Ferret Utility.\u00a0 Below is an example of how I retrieved the information.\u00a0 In my example here, I am using the Teradata Express for demonstration purposes only.<\/p>\n

1. Connected to the Teradata system, in this example I am connecting using the putty tool:<\/p>\n

\"Teradata<\/a><\/p>\n

2. Open the Database Window Supervisor screen using: cnsterm 6<\/strong><\/p>\n

Note: Window 6 is always used as the supervisor window.<\/p>\n

\"Database<\/a>

cnsterm 6<\/p><\/div>\n

3.\u00a0 To start the utility:\u00a0 start ferret<\/strong><\/p>\n

\"Start<\/a>

start ferret<\/p><\/div>\n

Note: watch the window number that the utility is going to start in, that number is needed in step 5.<\/p>\n

4. Exit the Database Window Supervisor screen by pressing Control -c: < ctrl -c ><\/strong><\/p>\n

\"CNRL_CtoExit\"<\/a><\/p>\n

5. Start the Database Window running with the number listed in Step 3: cnsterm < window # ><\/strong><\/p>\n

(eg. If in Step 3, the output states “Started ‘ferret’ in window 2”, then type: cnsterm 2)<\/p>\n

\"Window1\"<\/a>

cnsterm 1<\/p><\/div>\n

Note: When the Database Window is opened, information about the Ferret Utility will display.<\/p>\n

6.\u00a0 Now the internal table id is needed, by running tableid then the database and table in double-quotes: tableid “<database name>.<table name>”<\/strong><\/p>\n

7.\u00a0 With the internal three number table id retrieved from the previous command, set the scope for that table: scope table <table id><\/strong><\/p>\n

8.\u00a0 Type showblocks, and the information for the table that you want will display: showblocks<\/strong><\/p>\n

\"SHOWBLOCKS\"<\/a><\/p>\n

From Teradata:<\/p>\n

The SHOWBLOCKS command displays statistics about data block size and\/or the number of rows per data block for all the tables defined by the SCOPE command. SHOWBLOCKS can display WAL (Write Ahead Logging) log statistics also.<\/p>\n

Click to see more information on SHOWBLOCKS<\/strong><\/a>.<\/p>\n

9. Finally, to correctly close the utility, type “quit;”.\u00a0 The ferret utility will not close out of the cnsterm windows unless the “;” is after the quit statement: quit;<\/strong><\/p>\n

10. Then control -c to exit the window like the supervisor window shown above: < ctrl -c ><\/strong><\/p>\n

\"Exit<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Teradata support asked me for information from the “showblocks” command for a problem table in the Ferret Utility.\u00a0 Below is an example of how I retrieved the information.\u00a0 In my … Continue Reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":1097,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[69,67,71,70,66],"class_list":["post-1090","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teradata","tag-cnsterm","tag-ferret","tag-showblocks","tag-tableid","tag-teradata"],"_links":{"self":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1090"}],"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=1090"}],"version-history":[{"count":12,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1090\/revisions"}],"predecessor-version":[{"id":1136,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1090\/revisions\/1136"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1097"}],"wp:attachment":[{"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1090"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}