DISPLAY SESSION - 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ā„¢

Purpose

The DISPLAY SESSION command displays information for a specified session.

Syntax

{ DISPLAY | DI } { SESSION | SE }
  [ LONG | LON ] { ses_list | { USER | US } user_name }
LONG
LON
Displays additional detailed information for the specified sessions.
For backward compatibility, LONG is also valid after ses_lst, but it is only valid before USER.
ses_lst
One or more session numbers indicating the sessions for which information is to be displayed.
Multiple sessions can be specified as:
  • a range of contiguous session numbers, represented by the lowest and highest session in the range separated by a hyphen: nnnn-nnnn

    Multiple ranges can be separated by commas: nnnn-nnnn,nnnn-nnnn

  • A list of discontiguous session numbers separated by commas: nnnn,nnnn,nnnn
  • Any combination of ranges and lists of session numbers: nnnn-nnnn,nnnn,nnnn
where nnnn is a session number in decimal format. To list currently connected sessions and see possible values for nnnn, use the DISPLAY GTW command.
user_name
The name of the user account for which you want to display session information.

Usage Notes

Before using the DISPLAY SESSION command, you must select the host group from which the session is running using the SELECT HOST command. For information, see SELECT HOST.

By default, the Teradata Database system displays the short-form report containing the following information:
  • User Name
  • IP address
  • TCP socket number
  • State
  • Event
  • Action
  • Partition
  • Authentication method
  • Client Security Policy
  • Proxy Security Policy
  • Recoverable Network Protocol

The Authentication field has the values shown in the following table.

The value... Indicates...
Database that the database provided the authentication method.
This was the normal logon method before the implementation of single sign on.
TDGSS-returned method an authentication method returned by the Teradata Generic Security Service (TDGSS).

For more information on TDGSS, see Teradata Vantageā„¢ - Advanced SQL Engine Security Administration, B035-1100.

The long-form report gives a detailed connect display for a selected session. It includes all of the information displayed by the default short format, and adds the following information:
  • The Account associated with the User Name, if any.
  • Teradata Database system mailbox information.
  • I/O statistics for the session.
  • The authentication negotiating mechanism used, if any.

The long-form report is useful for field service personnel when diagnosing gateway problems.

For information on the descriptions of the valid states, events, and actions for the DISPLAY SESSION command, see Session States, Events, and Actions.

Displaying a Session

To display a session, do the following:

  1. To select a host group (for example, host group 52), type:

    se host 52

    The Teradata Database system displays the following:

    52>

  2. To display a session (for example, session 1040), type:

    di se 1040

Example: Displaying session information

To display session 1040 in the default (or short) form, type:

> di se 1040

gtwglobal displays the following output:

Session 1040 connected to GTW 8193 is assigned to PE 16383 
of host 1

User Name                      IP Addr         Port
------------------------------ --------------- ----------
DBC                            192.0.2.30      27399

State                          Event                    Action
------------------------------ -----------------------  -----------------
CS_CLIENTWAITNOTRAN            CE_STARTMSGRSPNOTRAN     CA_SENDDBSRSP

Partition        Authentication 
---------------- -------------- 
DBC/SQL          DATABASE       

Client Security Policy   Proxy Security Policy
----------------------   ---------------------
No Policy

Recoverable Network Protocol
--------------------------------
Not Supported

Example: Displaying session information (long format)

To display session 1000 in the long form, type:

> di se 1000 long

gtwglobal displays the following output:

di sess 1000 long 

Session 1000 connected to GTW 22528 is assigned to PE 30719 
of host 1 

User Name            Account              IP Addr         Port
-------------------- -------------------- --------------- ----------
DBC                                       127.0.0.1       55837 

State                          Event                    Action
------------------------------ ------------------------ --------------
CS_CLIENTWAITNOTRAN            CE_CONTINUEMSGRSPOK      CA_SENDDBSRSP 

Partition        Authentication NegotiatingMechanism
---------------- -------------- --------------------
DBC/SQL          DATABASE       TDNEGO 

Client Security Policy     Proxy Security Policy
----------------------     ---------------------
No Policy 

Recoverable Network Protocol
--------------------------------
Not Supported 
StrMbx:  01 00 77ff 00000002 0000 00 00
CntMbx:  02 00 77ff 00000000 040d 00 00
AbtMbx:  02 00 77ff 00000000 030d 00 00 

HostMessageReads  :                  18
HostBlockReads    :                   9
HostReadBytes     :                2384
DbsMessageReads   :                   5
HostMessageWrites :                   9
HostBlockWrites   :                   9
HostWriteBytes    :               20663
DbsMessageWrites  :                   5

Example: Specifying a list of sessions that includes a range

> di se 1119-1120,1117

Session 1119 connected to GTW 22528 is assigned to PE 30718
of host 1

User Name                      IP Addr         Port
------------------------------ --------------- ----------
DBC                            198.51.100.0    43727     

State                          Event                    Action
------------------------------ -----------------------  -----------------
CS_CLIENTWAITNOTRAN            CE_STARTMSGRSPNOTRAN     CA_SENDDBSRSP           

Partition        Authentication
---------------- --------------
DBC/SQL          DATABASE      

Client Security Policy           Proxy Security Policy           
-------------------------------- --------------------------------
No Policy                                                        

Recoverable Network Protocol    
--------------------------------
Not Supported                   

Session 1120 connected to GTW 22528 is assigned to PE 30719
of host 1

User Name                      IP Addr         Port
------------------------------ --------------- ----------
ETL03                          198.51.100.23   43728     

State                          Event                    Action
------------------------------ -----------------------  -----------------
CS_CLIENTWAITNOTRAN            CE_STARTMSGRSPNOTRAN     CA_SENDDBSRSP           

Partition        Authentication
---------------- --------------
DBC/SQL          DATABASE      

Client Security Policy           Proxy Security Policy           
-------------------------------- --------------------------------
No Policy                                                        

Recoverable Network Protocol    
--------------------------------
Not Supported                   

Session 1117 connected to GTW 22528 is assigned to PE 30718
of host 1

User Name                      IP Addr         Port
------------------------------ --------------- ----------
ETL02                          198.51.100.21   43725     

State                          Event                    Action
------------------------------ -----------------------  -----------------
CS_CLIENTWAITNOTRAN            CE_STARTMSGRSPNOTRAN     CA_SENDDBSRSP           

Partition        Authentication
---------------- --------------
DBC/SQL          DATABASE      

Client Security Policy           Proxy Security Policy           
-------------------------------- --------------------------------
No Policy                                                        

Recoverable Network Protocol    
--------------------------------
Not Supported 

Example: Displaying all current sessions of a specified user

> di se us dbc 

User DBC has 2 sessions 

Session 1116 connected to GTW 22528 is assigned to PE 30719 
of host 1 

User Name                      IP Addr         Port
------------------------------ --------------- ----------
DBC                            198.51.100.255  43724    

State                          Event                    Action
------------------------------ -----------------------  ----------------- 
CS_CLIENTWAITNOTRAN            CE_STARTMSGRSPNOTRAN     CA_SENDDBSRSP  

Partition        Authentication
---------------- -------------- 
DBC/SQL          DATABASE       

Client Security Policy           Proxy Security Policy           
-------------------------------- -------------------------------- 
No Policy 
 
Recoverable Network Protocol    
-------------------------------- 
Not Supported                    

Session 1117 connected to GTW 22528 is assigned to PE 30718 
of host 1 

User Name                      IP Addr         Port
------------------------------ --------------- ---------- 
DBC                            198.51.100.255  43725    

State                          Event                    Action
------------------------------ -----------------------  ----------------- 
CS_CLIENTWAITNOTRAN            CE_STARTMSGRSPNOTRAN     CA_SENDDBSRSP 

Partition        Authentication
---------------- -------------- 
DBC/SQL          DATABASE       

Client Security Policy           Proxy Security Policy           
-------------------------------- --------------------------------  
No Policy 

Recoverable Network Protocol    
-------------------------------- 
Not Supported