The Teradata Viewpoint team is often asked how do I do this Teradata Manager function in Viewpoint? Although Teradata Viewpoint is fairly intuitive and offers excellent on-line help, it seemed worth creating an article related to this subject to accomplish two things. First, provide some high level guidance of what portlets may want to be considered for general Teradata Manager functionality. Secondly, provide a discussion forum for more in-depth Teradata Manager feature questions.
Note there is general agreement that a full Teradata Manager feature by feature translation guide would become too large and cumbersome to be effective. So keep reading if this is of interest to you and contribute accordingly with any items you would like discussed.
This article will go through the high level breakdown of Teradata Manager high level feature groups with indications of what Viewpoint portlets should be considered for that functional equivalence. Pertinent to this discussion are the existing articles on the Teradata Viewpoint 13.03 release and subsequent Teradata Viewpoint 13.03.00.04 patch release, both of which provide important information on the Teradata Manager transition to Viewpoint and Teradata Management Portlets. The Teradata Viewpoint 13.02 and Teradata Viewpoint 13.10 release articles provide information on the TASM / workload management portlets. All of these articles should be read if you have not done so already. Lastly, make sure you review the latest Teradata Viewpoint Configuration Guide as this has additional Teradata Manager transition information.
The Teradata Manager feature functionality tools are presented in four main feature groups:
As seen below in the Teradata Manager toolbar. Other items shown are for general navigation, formatting, etc.
Before diving into each of the feature groups, note that "Help" is replaced in Teradata Viewpoint with the built in on-line help implementation. Help in Viewpoint is found in the upper right corner and identified by the quetion mark icon shown below.
Now that help is covered, let's go through each of the feature function groups.
The "Monitor" menu is comprised of the following choices:
The "Dashboard" is documented as displaying the following information. Each item is shown with the associated Viewpoint portlet or portlets in italics that provide similar information. Overall, the health of a Teradata system is defined in Viewpoint through the System Health portlet.
The "Sessions" and "Session Information" provided similar functionality, all of which is now offered in the Query Monitor portlet. As a feature addition, personal session information for any particular user can be displayed in the My Queries portlet.
The "Nodes" and "Vprocs" information primarily is replicated in the Node Resources portlet although trend information for some of this information is also available in the Capacity Heatmap or Metrics Graph trending portlets.
Last but certainly not least of the monitoring tools is "Performance Monitor" or maybe better known as just "PMON". PMON is described as providing performance data on four sets of data listed below with the associated Viewpoint portlet or portlets replacements listed in italics.
Note that the monitoring rates for data collection some of which are specified in PMON are covered in the Viewpoint Admin menus under the Teradata Systems choice. Review the Data Collectors and Monitor Rates options.
The "Investigate" menu is composed of the following choices. Note the included migration status of each:
The "Analyze" menu is comprised of the following choices. Note the included migration status of each:
The "Trends" menu choice provides resource usage trending which like the "Resource History" menu can now be found in the Capacity Heatmap, Metrics Graph, and Metrics Analysis portlets. The "Trends" menu also provides trend information for workload definitions that can be found in the Workload Monitor and Workload Health portlets. Regarding DBQL reporting, there will continue to be a need for the Database Query Log. However the Viewpoint DCS is a data repository with similar data, just not to the extent of DBQL, although it provides a vast majority of the value in a much easier access interface.
The "Administer" menu also has a variety of choices to consider. These are included in the following list where some have the migration status included on the line with others requiring more explanation and included below the list.
The "Teradata Manager" option is used to configure Teradata Manager, set up alerts, and data collection. This is done for Viewpoint in the Viewpoint Admin menus and in particular under the Teradata Systems and Alert Setup menu choices.
Regarding the Priority Scheduler Administrator or often referred to as just PSA, a business decision was made to not bring that forward into Teradata Viewpoint. However all priority scheduler configuration operations can still be done via the "schmon" command. To make transition easier, one can use PSA to dump the set of schmon commands equivalent to each PSA profile one has.
So that is the high level overview of the status of Teradata Manager transition to Viewpoint. As mentioned in the introduction of this article, this is not a one by one feature transition but provides direction on where to start looking. This also allows for additional detailed discussions, as necessary, through comments to this article.
Hope this is helpful.