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.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.