Check for Logged On Sessions | Teradata Vantage - 17.00 - 17.05 - Checking for Logged On Sessions - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

You may need to check if sessions are running on the system to warn users when you want to bring Teradata Vantage 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 Teradata Vantage™ - Database Utilities , B035-1102 ). 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.