DISPLAY USER - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

The DISPLAY USER command returns a list of connected sessions whose names match the user name.

Syntax

{ DISPLAY | DI } { USER | US } user_name
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