
Teradata Manager - Where is that in Viewpoint?
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.
- Virtual utilization and Physical utilization: Node Resources
- Sessions: System Health or Query Monitor
- Transaction rate: Query Monitor or Todays Statistics or Capacity Heatmap or Metrics Graph
- Response time: Todays Statistics
- I/O per transaction: Capacity Heatmap or Metrics Graph
- Recent history graphs showing trends: Capacity Heatmap or Metrics Graph
- Workload snapshots and history: Workload Health or Workload Monitor
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.
The "TDWM" information was specific to TASM and workload management monitoring and reporting. All of this information is now available in the Workload Health or Workload Monitor 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.
- General health information (configuration and summary): System Health
- Resource information (nodes and vprocs): Node Resources
- Session Information (statistics and lock information): Todays Statistics and Lock Viewer
- Historical session information: Query Monitor
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:
- Audit Log: Not migrated due to lack of usage and other log options.
- Error Log: Not migrated as this was only available for MP-RAS OS systems.
- Space Usage: Replaced by Space Usage portlet.
- Logon/Logoff History: Query the dbc.logonoff table or utilize the Query Monitor portlet.
- Locking Logger: Replaced by Lock Viewer portlet.
- Alert Viewer: Replaced by Alert Viewer portlet.
- System Emulation Tool (TSET): Remains a TTU product offering accessible from the Windows Start menu.
- Visual Explain: Remains a TTU product offering accessible from the Windows Start menu.
The "Analyze" menu is comprised of the following choices. Note the included migration status of each:
- Trends: See below.
- Resource History: Capacity Heatmap, Metrics Graph, and Metrics Analysis portlets.
- Statistics Wizard: Remains a TTU product offering accessible from the Windows Start menu.
- Index Wizard: Remains a TTU product offering accessible from the Windows Start menu.
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.
- Teradata Manager: See below.
- Teradata Database: Link to Teradata Administrator, a TTU product accessible from the Windows Start menu.
- Database Console: Replaced by Remote Console portlet.
- Alert Policies: Found in the Viewpoint Admin menu under Teradata Systems and the Alerts option.
- SQL Assistant: Remains a TTU product but is also complimented by the SQL Scratchpad portlet.
- BTEQ: Remains a TTU product offering accessible from the Windows Start menu.
- Teradata Database Setup: Similar setup for Viewpoint is available under the Teradata Systems menu.
- Statistics Collection: Functionality available through the Statistics Wizard TTU product.
- Move Space: Use the Space Usage portlet or the Teradata Administrator TTU product.
- Move Database: Functionality available through the Teradata Administrator TTU product.
- Workload Management: See below.
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.
The "Workload Management" choice offers four options related to workload management.
- Dynamic Workload Manager: Replaced by Workload Designer portlet.
- Workload Analyzer: Remains a TTU product offering.
- Priority Scheduler (PSA): See below.
- Query Scheduler: Remains a TTU product offering.
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.
Hello Gary,
Thanks for this "Teradata Manager" and "ViewPoint" comparison article.
At present in Teradata Manager, if we go to "Remote Console" then we can redirect output to file.
Remote Console --> Options --> Redirect Output...
This is helpful is many cases. I don't see this functionality in "Remote Console" portlet in ViewPoint. Can you please tell me if this is cancelled or Am I missing anything while checking remote console portlet?
I can see there are many differences in look for "Workload Designer portlet" and "Dynamic Workload Manager". Can you please document high-level points for comparison between "Dynamic Workload Manager" and "Workload Designer portlet"?
Thanks & Regards,
Shrinivas Sagare
Thanks & Regards,
Shrinivas Sagare
Java script based web engine.. write content to local file system is quite a challenge.. think about someone write a java script webpage and start dumping virus to your local pc.. how would you like that???LOL..
well, maybe need a trusted java applet embeded in pages or webstart app to redirect output.