Session State Display - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

The session state display consists of session identifier information and session state details. Displays for sessions involved in FastLoad, MultiLoad, FastExport, or Archive and Recovery operations provide additional information described later.

If a session is idle, only the session identifier information is displayed, as shown below.

Host Session PE DBC User ID
---- ------- -- -----------
 110 1006    11 DBC

The columns for the Session Identifier display the following information.

The column named... Contains the...
Host logical host identifier.
Session session identifier.
PE PE number of the PE to which the session is assigned.
DBC User ID user assigned to the session.

If a session is active, and not part of a FastLoad, MultiLoad, FastExport, or Archive and Recovery operation, the following session state detail information displays.

Session State Query Results : 00/06/15 14:14:13

Host Session PE DBC User ID
---- ------- -- -----------
 110 1006    11 DBC

State Details : ACTIVE

Statements Dispatched Time     CPU Usage Accesses
---------- ---------- -------- --------- --------
         1          1 14:22:09         2       22

Session State Details During Stored Procedure Execution

If a SQL or external stored procedure is being executed, the following session state information is displayed.

Session State Query Results : 00/06/15 13:14:13

Host Session PE DBC User ID
---- ------- -- -----------
 110 1006    11 DBC

State Details : ACTIVE (Stored Procedure is executing)

The State Details correspond to the latest SQL request that the stored procedure executed.

Session State Details Pertaining to the Teradata Index Wizard

Query Session reports the index analysis state pertaining to the Teradata Index Wizard. If a workload is being analyzed for indexes, the following session state information is displayed.

Session State Query Results : 02/04/15 12:22:03

Host   Session  PE     DBC User ID
----   -------  -----  -----------
  52   1893     16383  USER1
 
State Details: <status>
                Analyzing a workload for index recommendations.