16.20 - Gateway Improved Session Status Reporting - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine Release Summary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Release Notes
Publication ID
B035-1098-162K
Language
English (United States)
Last Update
2019-05-03

The Gateway Global utility DISPLAY SESSION command has been enhanced to support passing ranges and lists of sessions for which to display session information. It also supports a new USER argument that displays session information for all current sessions of a specified user account.

The DISPLAY STATS command has been enhanced to support a new USER argument that displays statistics for all current sessions of a specified user, and optionally allows automatically rerunning the report at specified intervals a specified number of times.

Benefits

  • Simplifies obtaining and comparing session information that would otherwise have required the issuance of several gtwglobal commands in succession.
  • Increased flexibility in session and statistics reporting by allowing reporting on all sessions in use by a specified user.
  • Easily compare session and statistical information at specified time intervals automatically with a single gtwglobal command. This allows easy observation of changes in the statistics with time, to help determine whether a session is stuck or merely running slowly.

Additional Information

For more information on the DISPLAY SESSION and DISPLAY STATS commands, see Gateway Global in Teradata Vantageā„¢ - Database Utilities , B035-1102 .