17.10 - DISPLAY USER - 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 USER command returns a list of connected sessions whose names match the user name.

Syntax

{ DISPLAY | DI } { USER | US } user_name

Syntax Elements

user_name
Name of the user.

Usage Notes

Before using the DISPLAY USER command, you must select the host group from which the sessions are running using the SELECT HOST command. For more information, see SELECT HOST.

The DISPLAY USER command displays this information:
  • Vproc number of the gateway the session is connected to
  • Node the gateway vproc is running on, in the format cabinetID-moduleID
  • Session number
  • Parsing Engine that the session is assigned to
  • Node the PE vproc is running on, in the format of cabinetID-moduleID
  • Local? can be Yes or No. Yes indicates the PE and gateway vprocs are running on the same node.
  • User name
  • IP address
  • Status indicating the following:
    • Connected
    • Forced
    • Gone
    • Killed
  • SP (Client Security Policy)
  • PP (Proxy Security Policy)

Example: Displaying sessions of a specified user

To display a information about a user, type:

di us test

The following appears:

User DBC has 1 session

GTW   Node   Session PE    Node   Local? User  IP Adr        Status    SP PP RNP
----- ------ ------- ----- ------ ------ ----- ------------- --------- -- -- ---
22528 001-01 1238    30719 001-01 Yes    TEST  153.64.183.89 CONNECTED N     No