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:
|
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
|
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