{"id":2024,"date":"2021-12-31T13:17:46","date_gmt":"2021-12-31T13:17:46","guid":{"rendered":"https:\/\/www.theSQLReport.com\/?p=2024"},"modified":"2021-12-31T13:21:21","modified_gmt":"2021-12-31T13:21:21","slug":"setting-a-teradata-maintenance-window-updated-2021","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=2024","title":{"rendered":"Setting A Teradata Maintenance Window &#8211; Updated 2021"},"content":{"rendered":"<p>Teradata in a recent design change moved where to set the Maintenance Window with the roll out of their newer equipment.<\/p>\n<p>Note: The reason that you would want to set a Teradata maintenance window is to avoid setting off alarms at Teradata support from something like a database or server restart.\u00a0 This will avoid the possible phone call asking if your Teradata system ok.<\/p>\n<p>1. Connect using the VNC Viewer to the workstation of the system you will be setting the Maintenance Window.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow01.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2028\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow01.jpg\" alt=\"\" width=\"485\" height=\"275\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow01.jpg 485w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow01-300x170.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow01-210x119.jpg 210w\" sizes=\"(max-width: 485px) 100vw, 485px\" \/><\/a><\/p>\n<p>2. Logging in as root<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow02.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2029\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow02.jpg\" alt=\"Root Logon\" width=\"393\" height=\"243\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow02.jpg 393w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow02-300x185.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow02-210x130.jpg 210w\" sizes=\"(max-width: 393px) 100vw, 393px\" \/><\/a><\/p>\n<p>3. This is where the first big change comes from, click on the SOV webpage button (used to be the SWeb client button).<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow03.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2030\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow03.jpg\" alt=\"SOV Webpage\" width=\"1137\" height=\"247\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow03.jpg 1137w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow03-300x65.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow03-1024x222.jpg 1024w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow03-768x167.jpg 768w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow03-210x46.jpg 210w\" sizes=\"(max-width: 1137px) 100vw, 1137px\" \/><\/a><\/p>\n<p>4. When the Server Management Web Service browser opens, click on the Server Management Web Client link. It even says that this is where Maintenance Window is set.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow04.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2031\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow04.jpg\" alt=\"\" width=\"1242\" height=\"431\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow04.jpg 1242w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow04-300x104.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow04-1024x355.jpg 1024w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow04-768x267.jpg 768w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow04-210x73.jpg 210w\" sizes=\"(max-width: 1242px) 100vw, 1242px\" \/><\/a><\/p>\n<p>5.\u00a0 Asked again to login, this will be a different user name &amp; password than the previous login to access the VNC Viewer. The default login name was changed from admin to tdadmin, but the default password stayed the same.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow05.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2032\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow05.jpg\" alt=\"\" width=\"866\" height=\"367\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow05.jpg 866w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow05-300x127.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow05-768x325.jpg 768w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow05-210x89.jpg 210w\" sizes=\"(max-width: 866px) 100vw, 866px\" \/><\/a><\/p>\n<p>6.\u00a0 In the top right corner of the browser, click on the three bars.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow06.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2033\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow06.jpg\" alt=\"\" width=\"425\" height=\"172\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow06.jpg 425w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow06-300x121.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow06-210x85.jpg 210w\" sizes=\"(max-width: 425px) 100vw, 425px\" \/><\/a><\/p>\n<p>7.\u00a0 A drop-down menu will appear, click on the Maintenance link.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow07.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2034\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow07.jpg\" alt=\"\" width=\"397\" height=\"685\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow07.jpg 397w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow07-174x300.jpg 174w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow07-122x210.jpg 122w\" sizes=\"(max-width: 397px) 100vw, 397px\" \/><\/a><\/p>\n<p>8.\u00a0 In the top right corner, click on the orange create button.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow08.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2035\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow08.jpg\" alt=\"\" width=\"1096\" height=\"129\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow08.jpg 1096w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow08-300x35.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow08-1024x121.jpg 1024w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow08-768x90.jpg 768w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow08-210x25.jpg 210w\" sizes=\"(max-width: 1096px) 100vw, 1096px\" \/><\/a><\/p>\n<p>9.\u00a0 A pop-up window will appear to collect the Maintenance Window information.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow09.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2036\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow09.jpg\" alt=\"\" width=\"654\" height=\"668\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow09.jpg 654w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow09-294x300.jpg 294w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow09-206x210.jpg 206w\" sizes=\"(max-width: 654px) 100vw, 654px\" \/><\/a><\/p>\n<p>10. A time line below the create button will appear that either stopping or editing the window can be done.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2026\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow10.jpg\" alt=\"\" width=\"1079\" height=\"246\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow10.jpg 1079w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow10-300x68.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow10-1024x233.jpg 1024w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow10-768x175.jpg 768w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow10-210x48.jpg 210w\" sizes=\"(max-width: 1079px) 100vw, 1079px\" \/><\/a><\/p>\n<p>11. Once the time runs out or the Maintenance Windows is completed, it will be marked as complete.<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow11.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2027\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2021\/12\/TeradataMaintenanceWindow11.jpg\" alt=\"\" width=\"1093\" height=\"215\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Teradata in a recent design change moved where to set the Maintenance Window with the roll out of their newer equipment. Note: The reason that you would want to set &hellip; <a class=\"readmore\" href=\"https:\/\/www.theSQLReport.com\/?p=2024\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":2027,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-2024","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teradata"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/2024"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2024"}],"version-history":[{"count":3,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/2024\/revisions"}],"predecessor-version":[{"id":2038,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/2024\/revisions\/2038"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/2027"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}