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.
- ses_lst
- One or more session numbers indicating the sessions for which information is to be displayed.
- 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:
- To select a host group (for example, host group 52), type:
se host 52
The Teradata system displays the following:
52>
- To display a session (for example, session 1040), type:
di se 1040
- To select a host group (for example, host group 52), type:
Example: Displaying session information
To display session 1040 in the default (or short) form, type:
> di se 1040gtwglobal 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 longgtwglobal 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