15.00 - Session State Display - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Session State Display

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 in this chapter.

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