15.00 - DISPLAY USER - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

DISPLAY USER

Purpose  

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

Syntax  

 

Syntax element...

Is the...

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” on page 664.

The DISPLAY USER command displays this information:

  • Session number
  • Parsing Engine that the session is assigned to
  • User name
  • IP address
  • Status indicating the following:
  • Connected
  • Forced
  • Gone
  • Killed
  • SP (Client Security Policy)
  • PP (Proxy Security Policy)
  • Example  

    To display a user (for example, user DBC), type.

    di us dbc
     
    User DBC has 20 sessions
     
    Session PE    User IP Adr        Status    SP PP
    ------- ----- ---- ------------- --------- -- --
    1001    16383 DBC  141.206.35.30 CONNECTED N
    1002    0     DBC  141.206.35.30 FORCED    N
    1003    16383 DBC  141.206.35.30 CONNECTED N
    1004    0     DBC  141.206.35.30 FORCED    N
    1005    16383 DBC  141.206.35.30 CONNECTED N
    1006    0     DBC  141.206.35.30 GONE      N
    1007    16383 DBC  141.206.35.30 CONNECTED N
    1008    16382 DBC  141.206.35.30 CONNECTED N
    1009    16383 DBC  141.206.35.30 CONNECTED N
    1010    16382 DBC  141.206.35.30 CONNECTED N
    1011    16383 DBC  141.206.35.30 CONNECTED N
    1012    16382 DBC  141.206.35.30 CONNECTED N
    1013    16383 DBC  141.206.35.30 CONNECTED N
    1014    16382 DBC  141.206.35.30 CONNECTED N
    1015    16383 DBC  141.206.35.30 CONNECTED N
    1016    16382 DBC  141.206.35.30 CONNECTED N
    1017    16383 DBC  141.206.35.30 CONNECTED N
    1018    16382 DBC  141.206.35.30 CONNECTED N
    1019    16383 DBC  141.206.35.30 CONNECTED N
    1020    16382 DBC  141.206.35.30 CONNECTED N