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

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢
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 Archive and Recovery, 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.