16.10 - Session State Display - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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