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.