Checking for Logged On Sessions - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

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 Teradata Administrator or Teradata Studio
  • Run a select on the DBC.SessionInfoV view.