TDWMEventMapping

Teradata® Database Application Programming Reference

brand
Software
prodname
Teradata Database
vrm_release
16.20
category
Programming Reference
featnum
B035-1090-162K

Purpose

Lists all objects that make up the system state.

Definition

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
    )
                  .
                  .
                  .
;

Usage Notes

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

Result Rows

Column Name Description
ObjectType Type of object, for example: an Event, Expression, SysCon, OpEnv, and a State.
ObjectId Internal object ID number.
ObjectName Name of the object.
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® Database 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® Database 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® Database 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® Database 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

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