Advanced SQL Engine | Utilities | Query Session (qrysessn) | Teradata Vantage - 17.10 - Query Session (qrysessn) - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)
The utility described is not available for as-a-service customers.

The Query Session utility, qrysessn, provides information about active Advanced SQL Engine sessions. It allows you to monitor the state of all or selected database sessions on all or selected logical host IDs attached to the Advanced SQL Engine. Query Session is also known as Session States.

This discussion of the information Query Session reports includes several sample Query Session displays.

The Query Session displays for sessions involved in FastLoad, MultiLoad (MLOAD), and FastExport operations are different from other session displays. These displays are described at the end of the discussion of Query Session.