15.00 - DISPLAY SESSION - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update



The DISPLAY SESSION command displays information for a specified session.



Syntax element



The number (in decimal) of the session for which information will be displayed.


Displays additional detailed information for the specified session.

Note: To list the possible values for ses_no, use “DISPLAY GTW” on page 645.

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” on page 664.

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



    that the database provided the authentication method.

    Note: This was the normal logon method before the implementation of single sign on.

    TDGSS-returned method

    an authentication method returned by the Teradata Database Generic Security Service (TDGSS).

    For more information on TDGSS, see Security Administration.

    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 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 Appendix C: “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:


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

    di se 1000


    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                    27399
    State                          Event                    Action
    ------------------------------ ----------------------- -----------------
    Partition        Authentication 
    ---------------- -------------- 
    DBC/SQL          DATABASE       
    Client Security Policy 		Proxy Security Policy
    ---------------------- ---------------------
    No Policy

    Recoverable Network Protocol
    Not Supported


    To display session 1040 in the long form, type:

    di se 1040 long

    gtwglobal displays the following output:

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

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

    State                         Event                    Action
    ----------------------------- ------------------------ -----------------

    Partition        Authentication 
    ---------------- -------------- 
    DBC/SQL          DATABASE        
    Client Security Policy 		 Proxy Security Policy
    ---------------------- ---------------------
    No Policy

    Recoverable Network Protocol
    Not Supported

    StrMbx:  01 00 3fff 0050 0000 02 00
    CntMbx:  02 00 3fff 0000 040d 02 00
    AbtMbx:  02 00 3fff 0000 030d 43 53

    HostMessageReads  :         10
    HostBlockReads    :          5
    HostReadBytes     :        699
    DbsMessageReads   :          2
    HostMessageWrites :          5
    HostBlockWrites   :          5
    HostWriteBytes    :       1245
    DbsMessageWrites  :          2