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.
- 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.
- 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 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:
- To select a host group (for example, host group 52), type:
se host 52
The Teradata Database system displays the following:
52>
- 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 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