16.10 - SESSION LIST - 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

Purpose

Lists all active client session connections to the Unity server.

Syntax

SESSION LIST [INTERRUPTED [ALL]];

Parameters

INTERRUPTED
Displays interrupted sessions with database errors.
INTERRUPTED ALL
Displays all interrupted sessions.

Examples

Lists managed and passive sessions to the Unity server.

unityadmin>  session list; 
Unity Session Number      : 1000
Client TDP Session Number : 1050
Associated endpoint       : region1_ept (1)
Username                  : testuser1
Logon Source              : fast	634	testuser1  bteq  01 LSS
Client IP Address         : 153.65.194.177
Connected Since           : 10/28 16:58:53
Mode                      : Read-Only (managed)
Error List                : DefaultErrorList
Session Routing           : managedrouting1
Session State             : Available (in transaction)
Session in transaction    : 1 day 15 hr 54 min 17 sec 
Ordered Read Systems      : [1*] flash [2] blaze
System Sessions:
    [1] flash - 5316060 (Active)
    [2] blaze - 5223551 (Active)
---------------------------------------------------------------
Unity Session Number      : 40001
Client TDP Session Number	: 1049
Associated endpoint      	:	region1_ept (1)
Username                  :	testuser1
Logon Source              : fast	630	testuser1  bteq  01 LSS
Connected Since           : 10/28 16:58:50
Mode                     	:	Passive
Error List               	:	DefaultErrorList
Session Routing           :	passiverouting1
Session State             :	Available (not in transaction)
System Sessions           :	flash - 5316059 (Active)
Output Description
Unity Session Number Number of the Unity session.
Client TDP Session Number Associated Unity Session Number.
Associated endpoint Name of the Endpoint associated with the session.
Username Name of the Teradata user.
Account Account string if specified.
Group Group name for the user if specified.
Define a group in the routing files or with the USER commands.
Client IP Address IP Address
Connected Since Time stamp set when a session begins.
Mode Mode indicates Read-only, Read-Write, or Passive.
Error List Error list associated with the session routing rule.
Session Routing Routing rule session is using.
Session State Availability for sessions.
Session in Transaction Length of time session has been in transaction (valid only for Managed Routing rules).
Ordered Read Systems [Optional] Read system associated with session routing rule. Only shown when the routing rule has the read system specified.
Ordered Write Systems [Optional] Write system associated with session routing rule. Only shown when the routing rule has the write system specified.
System Sessions Session names and Teradata session numbers. Shows which Teradata Database system is in use and status.

Lists information on an interrupted session with a database error. In this example, Unity is trying to access a database that does not exist.

unityadmin> session list INTERRUPTED;
---------------------------------------------
Unity Session Number      : 1000
Unity Transaction ID      : 0
System                    : jasonu4
Root Cause                : Yes
Interrupt Time            : 09/29 16:17:16
Time of Original Query    : 09/29 16:07:09
Error Code                : 3802
Error Text                : Database 'jason2' does not exist.
SQL Text                  : database jason2;
---------------------------------------------
Output Description
Unity Session Number Number of the Unity session.
Unity Transaction ID Number associated with transaction.
System System associated with interrupted session.
Root Cause Yes indicates the cause was from a database issue. No indicates the session was interrupted by another session.
Interrupt Time Timestamp when system became interrupted.
Time of Original Query Timestamp when session attempted to access database.
Error Code Code associated with error.
Error Text Text string indicating error.
SQL Text SQL Text string showing error.