17.10 - DISPLAY SESSION - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The DISPLAY SESSION command displays information for a specified session.

Syntax

{ DISPLAY | DI } { SESSION | SE }
  [ LONG | LON ] { ses_list | { USER | US } user_name }

Syntax Elements

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 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 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.
  • To display a session, do the following:

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

      se host 52

      The Teradata 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  

Example: Displaying the TLS version and Cipher Suite

> di se 1000 

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

User Name              IP Addr                       Port
---------------------- ----------------------------- ----------
DBC                    10.25.64.17                   55376

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

Partition        Authentication TLS      Cipher Suite
---------------- -------------- -------- -----------------------
DBC/SQL          DATABASE       TLSv1.2  TLS_AES_256_GCM_SHA384

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

Recoverable Network Protocol

If the current session is a legacy session, TLS version and Cipher will not display. The columns will appear as:

Partition        Authentication TLS      Cipher Suite
---------------- -------------- -------- -----------------------
DBC/SQL          DATABASE       Not Used