16.20 - System Performance Monitor and Production Control (PMPC) API Enhancements - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

Release 16.00 provides the following PMPC enhancements:

  • To support Flex Throttles:
    • Added ReqFlexReleased to MONITOR SESSION, MonitorMySessions, and MonitorSession.
    • Added EventClass to EVENT STATUS and TDWMEventMapping.
    • Additional event indicators added to EventKind in Statement 3 of EVENT STATUS and added to EventKind Result Rows in TDWMEventMapping.
    • Added FlexActive, FlexComplete, and FlexArrivals to TDWM SUMMARY and TDWMSummary.
    • Added FlexEligible to Statement 1 and Statement 2 of TDWM STATISTICS. Added FlexReleased to Statement 4 of TDWM STATISTICS.
    • Added FlexEligible to TDWMThrottleStatistics and TDWMGetDelayedQueries.
  • Added ReqMapNo, ReqMaxNumMapAMPs, ReqMinNumMapAMPs, and ReqSysDefNumMapAMPs to MONITOR SESSION, MonitorMySessions, and MonitorSession.
  • Added DefaultDBName to MONITOR SQL and MonitorSQLCurrentStep.
  • To support the ability to push SQL expressions, joins, and aggregations on remote systems: Added ReqRemoteHostIp and ReqServerName to MONITOR SESSION, MonitorMySessions, and MonitorSession.
  • Added AvailableAWTsForAll to MONITOR AWT RESOURCE and MonitorAMPLoad.
  • To allow users to track skewed spool usage by session: Added ReqHotAmpSpool and ReqHotAmpSpoolId to MONITOR SESSION, MonitorMySessions, and MonitorSession.

Considerations

If using the PM/API requests, you must use monitor software version 13 to report the data described in this feature.

Additional Information

For more information, see Teradata Vantageā„¢ Application Programming Reference, B035-1090.