15.10 - TDWMEventMapping - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Lists all objects that make up the system state.

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

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

 

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. See Resource Usage Macros and Tables for information.
  • System CPU Skew. This value is calculated by the CPU usage columns in the ResUsageSpma and ResUsageSps tables. See Resource Usage Macros and Tables for information.
  • WD CPU %. This value is calculated by the CPU usage columns in the ResUsageSpma and ResUsageSps tables. See Resource Usage Macros and Tables for information.
  • 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.
  • 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