TDWMEventMapping Function | Application Programming Reference | Teradata Vantage - 17.10 - TDWMEventMapping - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Lists all objects that make up the system state.

Syntax

REPLACE FUNCTION TDWM.TDWMEventMapping
  RETURNS TABLE (
    ObjectName VARCHAR(128) CHARACTER SET UNICODE, 
    ObjectType VARCHAR(10) CHARACTER SET LATIN,
    ObjectId INTEGER,
    ObjectActive CHAR CHARACTER SET LATIN,
    PrecSeverity INTEGER,
    EventKind VARCHAR(12) CHARACTER SET LATIN,
    EventClass VARCHAR(12) CHARACTER SET LATIN,
    StatusDate INTEGER,
    StatusTime FLOAT
    )
  ...
;

Syntax Elements

ObjectType
Type of object, for example: an Event, Expression, SysCon, OpEnv, and a State.
ObjectId
Internal object ID number.
ObjectName
Type of object, for example: an Event, Expression, SysCon, OpEnv, and a State.
ObjectActive
Status of the object:
  • 0 = Inactive
  • 1 = Active
PrecSeverity
Indicator of the Precedence or Severity of the SysCon or OpEnv object types only:
  • SysCon = Indicates the Severity of the SysCon.
  • OpEnv = Indicates the Precedence of the OpEnv.
EventKind
Text string of the specific event. You may see the following strings as a result of this interface:
  • User Defined SysCon. The user-defined system condition.
  • User Defined OpEnv. The user-defined operating environment.
  • Time Period. The time range.
  • Fatal AMPs. The number of AMPs with the status of FATAL.
  • Fatal PEs. The number of PEs with the status of FATAL.
  • Fatal GTWs. The number of Gateways with the status of FATAL.
  • Nodes Down. The % of nodes down within a clique.
  • Minimum available AWTs. The number of in-use AMP AWTs.
  • AMPs In Flow Control. The number of AMPs in flow control.
  • Average System CPU. This value is calculated by the CPU usage columns in the ResUsageSpma and ResUsageSps tables and compared to the threshold defined by the user in this event. For more information, see Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.
  • System CPU Skew. This value is calculated by the CPU usage columns in the ResUsageSpma and ResUsageSps tables. For more information, see Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.
  • WD CPU %. This value is calculated by the CPU usage columns in the ResUsageSpma and ResUsageSps tables. For more information, see Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.
  • WD SLG Response. The % of request in this WD that have met the defined Response Time Service Level Goal (SLG).
  • WD SLG Throughput. The % of request in this WD that have met the defined Throughput SLG.
  • WD Arrivals. The number of new requests for this WD.
  • WD Active Request. The number of currently active requests in this WD.
  • WD Delay Queue Depth. The number of requests on the Delay Queue for this WD.
  • WD Delay Query Time. The max time a request has been delayed in this WD.
  • WD AWT Wait Time. The max time a request was on an AMP mailbox waiting for an AWT.
  • TwmFlexAvailableAWTsEvent. The number of AWTs that are available for work.
  • TwmFlexAvgCpuEvent. This value is calculated by the CPU usage columns in the ResUsageSpma and ResUsageSps tables and compared to the threshold defined by the user in this event. For more information, see Teradata Vantage™ - Resource Usage Macros and Tables, B035-1099.
EventClass
This field is only valid for Object Type of Event and Expression. The values are:
  • 1 = OpEnv
  • 2 = SysCon
  • 3 = FlexThrtl

Usage Notes

The TDWMEventMapping function provides similar functionality to an EVENT STATUS request. For more information about this interface, see EVENT STATUS.

Example: Using TDWMEventMapping

SELECT ObjectName, ObjectType, ObjectId, ObjectActive
  FROM TABLE (TDWM.TDWMEventMapping()) AS t1
  where objecttype='syscon';
 *** Query completed. 3 rows found. 4 columns returned.
 *** Total elapsed time was 1 second.
ObjectName            ObjectType  ObjectId  ObjectActive
----------            ----------  --------  ------------
Extra SysCon1         SYSCON      225       I
Degraded SysCon       SYSCON      250       I
Normal                SYSCON      200       A