16.10 - Session Details View - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
The Session Details view contains the following overview for each session.
Field Description
State State of session.
Idle Time Timestamp when session started waiting.
Endpoint name Timestamp when session connected.
Routing Name Name of routing rule.
Error List Name Name of Error List.
Root Blocker Cause of session blocking.
Blocking Any sessions that are blocked by this session.
The Session info for each session includes the connection information.
Field Description
User name User associated with session.
Database Database associated with session.
Client IP Address Location of session.
Client Host Name Location of client host.
Connect Time Timestamp when session connected.
Logon Source User logon location.
The Session Details view also contains Teradata Sessions.
Field Description
Session ID Generated Session identification where the query is running.
System Name System name where the query is running.
State Icon Icon showing state of session.
In State Time query has been in current state.
REQ CPU Number of seconds CPU has been used for query.
Workload Workload where the query is running.
CPU Number of CPU seconds query has used in the last minute.
I/O Number of disk input/outputs the query has performed in the last minute.

The Session Details view contains Locks info.

Field Description
Lock Name Lock name.
Status Status of lock.
Lock Type Type of lock.
Row Hash Row hash associated with session lock.
Lock Mode Lock Modes include the following: Exclusive, Access, Write, and Read.
Lock ID Generated Lock identification.