We are pleased to announce the release of Teradata Multi-System Manager (TMSM) release 13.11 on September 28, 2011. This release allows TMSM to integrate with our newest product in the Dual Systems / Analytical Ecosystem family – Teradata Unity. TMSM was also enhanced to provide additional table validation options and support for other client platforms. Additionally, we have added integration with the Common Alerting Mechanism (CAM) / Teradata Alerts that was released with Viewpoint.
The above diagram shows several of the Teradata TMSM portlets and integration with Teradata Unity
What is Teradata Multi-System Manager?
TMSM provides a powerful solution for monitoring, administration, and control of single and multiple Teradata data warehouse environments (ecosystems)
Details of the TMSM 13.11 release:
Enhanced Integration with other Teradata products and features
Support and integration with Teradata Unity
TMSM Component Health Portlet
Table Health Portlet shows table status across TD systems, including if the table is managed by Unit
TMSM Internal Repository upgraded to Teradata 13.10
The TMSM repository, which is an internal instance of the Teradata database, has been upgraded from Teradata 12 to Teradata 13.10
Integration with the Common Alerting Mechanism (CAM) / Teradata Alerting
Consolidates alert and user definitions, users no longer need to define in two applications (Viewpoint and TMSM) when setting up alerts
Enhanced Usability – convenience and productivity features
New TMSM client packages for the following platforms. These packages are installed on servers in the Teradata Analytical Ecosystem allowing TMSM to monitor hardware condition and processes on that server. TMSM supports the following platforms:
Additional options for table validation
[DB] - database name that is being validated
[TBL] - table name that is being validated
[TDP_ID] - TDPID of the system on which table validation SQL will run.
[UOW_ID] - UOWId associated to the validation.
[UOW_TS] - the Unit of Work timestamp.
[UOW_FROMTS] - the Unit of Work from timestamp (if none was specified for the UOW, it will be equal to UOW_TS).
[UOW_DATE] - the date part of the Unit of Work timestamp
[UOW_CLASS] - Unit of Work class (if none was specified for the UOW it defaults to the ResourceId of the process that created it).
[RES_ID] - ResourceId of the process that triggered the table validation
[RES_TYPE] - ResourceType of the process that triggered the table validation
[EVENT_TYPE] - Event type of the event that triggered the validation
Want more information?
Access the following documents from the Teradata Publications Website:
Multi-System Manager 13.10 publications
Teradata Multi-System Manager User Guide
Teradata Multi-System Manager Installation Guide
Teradata Multi-System Manager Configuration Guide
Teradata Multi System Manager API Specification
We are upgrading the TMS (VP,TMSM,Unity,DataMover) to new version. So far we haven't open the other system (site in another state) in Dual Active Environment.
I would like to know the process for configuring the TMSM and Unity porlets in Viewpoint. Is that mentioned anywhere in the manuals/documents?