15.00 - DISPLAY SESSION - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DISPLAY SESSION

Purpose  

The DISPLAY SESSION command displays information for a specified session.

Syntax  

 

Syntax element

Description

ses_no

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

LONG

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

    Indicates...

    Database

    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:

    52>

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

    di se 1000

    Example  

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

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

    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