16.10 - DISPLAY USER - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

Purpose

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

Syntax



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 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

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