16.10 - Checking for Logged On Sessions - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

You may need to check if sessions are running on the system to warn users when you want to bring Teradata Database down or disable logons. There are several ways to check if there are established sessions on the system.

  • Run the Query Session utility (see “Query Session (qrysessn)” in Utilities). If there are sessions, it will report as follows:
    Session state query results : 08/07/16  14:28:59
    
     Host   Session  PE     DBC User ID
     -----  -------  -----  -------------------------------
         1     1015  16383 JohnSmith
    
     State details : IDLE 
  • Use BTEQ or Teradata Studio
  • Run a select on the DBC.SessionInfoV view.