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
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.