Teradata is pleased to announce the official release of Teradata Viewpoint 13.10 effective August 27th, 2010.
The primary focus of this Viewpoint release is the "Workload Designer" portlet for Teradata Active System Management (TASM) / workload management configuration. The Workload Designer portlet is an addition to the TASM Portlets bundle joining the Workload Health and Workload Monitor portlets introduced with the Teradata Viewpoint / TASM Portlets 13.02 release in January 2010.
The majority of effort for the Viewpoint 13.10 was development of the Workload Designer portlet. Delivery of this new portlet was critical as the TTU product Teradata Dynamic Workload Manager (TDWM) 13.0 is the last release of that product. So TASM / workload management against a Teradata DB 13.10 system will require usage of Workload Designer and of course Teradata Viewpoint. Note that this new portlet can also be used against Teradata DB 12.0 and 13.0 versions allowing overlapping Teradata releases. The Teradata Viewpoint 13.10 version also supports new TASM 13.10 features (more WDs, improved utility management, and common classifications). A summary of these new features is discussed later in this article. Customer demand drove realization of the next new Viewpoint 13.10 feature, queryband column addition to the query portlets summary view. So one can now view queryband information at both the summary and detail query portlet views. As with past Viewpoint releases, Viewpoint 13.10 represents a patch update for Viewpoint Foundation software, Teradata Management, TASM, and Self Service Portlets.
As mentioned in the summary, the vast majority of effort for this release was creation of the new "Workload Designer" portlet. This portlet provides full TASM configuration in a new more intuitive, easy to use interface. Note that this overview should not be considered a TASM feature explanation or a TASM configuration training session. This is just giving a preview of what this latest portlet offering can provide.
The interface is built to be intuitive and provides easy recognition of workload management features like Filters, Throttles, Workloads, Exceptions, etc. When working on a ruleset, the Workload Designer primary screen will appear as follows:
You will notice the various features are presented across the top of the portlet for easy navigation. Drilling down into States allows simple point-and-click operations for adding new events, environments, and health conditions. This state matrix allows one to set different TASM rules based on planned and unplanned events. For instance, automated rule changes when entering the weekend batch window or when an unanticipated hardware issue puts the system in a degraded state.
Also notice the "Setup Wizard" button to provide assistance for those less familiar with TASM State Matrix features and setup. As with any Viewpoint portlet, you also have in-depth documentation of all portlet aspects in the on-line help, which is just a click away on the Question Mark icon in the upper right corner of the Viewpoint panel.
TASM configuration is just a traversal through the other options to configure states, sessions, filters, throttles, workloads, and exceptions. While working on a ruleset, it will be stored on Viewpoint until such time as you want to deploy it for possible usage. The ruleset will then be stored in Teradata for activation when necessary. Here's one last Workload Designer screen shot showing the available choices when configuring workloads.
The workload configuration header shows additional tabs for Workloads where classification of new workload definitions would be done. SLG Summary for setting service level goals against workloads. Evaluation Order for setting which workloads should be considered for classification prior to others and so forth.
Again this is just an appetizer into the capabilities of the new Workload Designer portlet, our most sophisticated portlet to date, and further advancement to Teradata's industry leading workload management offering.
It is worth mentioning the new TASM / workload management features being introduced with the Teradata 13.10 Database release. These new features are supported within the Workload Designer 13.10 portlet release. These new features include:
1) Improved Utilities Management: Provides overall improvement to TASM load utility management including improved classification criteria, workload-level utility throttling, utility load balancing, centralized load session management, and load Unit-of-Work (UOW) management.
2) Common Classifications: Achieves consistent classification criteria across all TASM features by applying full workload definition (WD) classifications to system filters and system throttles, providing a superset of classification options.
3) Additional TASM Workload Definitions: Extended the number of WDs to 250 from the prior limit of 40. TASM best practices still cite 12-30 WDs as sufficient for the majority of customers.
The summary section mentioned addition of querybands as a new column to the query portlets summary view. Here's an example of the Query Monitor portlet showing the display configuration screen and the new queryband column for possible inclusion. The on-line help within Viewpoint describes this column as an "Entire query band string (query bands are a set of name-value pairs defined by the user to tag sessions or transactions with an ID through an SQL interface)".
The queryband column header, by default, is not displayed. So one will need to go into the display configuration as shown above and select the new column for display.
Lastly but certainly worth mentioning is the available customer training for Teradata Viewpoint offerings. At the time of this article posting, there are two Teradata Education Network (TEN) courses that can assist you in better understanding Teradata Viewpoint and the associated portlet bundles. These are:
Check with your Teradata accounts team or Teradata Education Network for more information on Teradata training.
In closing, we hope that you find the Teradata Viewpoint and TASM Portlets 13.10 release as cool as we do.
I have viewpoint 14.10. I have created 3 workloads for high, medium and low levels (timeshare metod) and activated same. but in workload health portlet one of the workloads (workload in medium level) is showing inactive.
Do you have any idea, why it is showing inactive?
Viewpoint 14.10 is getting a bit outdated as we already have Viewpoint 15.00 and 15.10 releases available. I have not however heard of this issue so I would recommend upgrading to 15.10 to see if that solves your issue or you can submit a Teradata Support Incident. Note that Viewpoint 15.10 supports the following Teradata DB versions (15.10, 15.00, 14.10, 14.00, 13.10). So it has an extensive Teradata DB support model.
In workload health portlet ,If the workload is in INACTIVE state means,no queries are assigned to that workload at that particular time.You can see in the detailed view(click on workload) of workload that,no queries are running under that workload.You can also see in the query monitor that,no queries are running under workload.