DISPLAY USER - Analytics Database - Teradata Vantage

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢

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