Checking for Logged On Sessions - Teradata Database

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.