Database Engine 20 | Utilities | Query Session (qrysessn) | Teradata Vantage - Query Session (qrysessn) - Teradata Vantage - Database Engine 20

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Database Engine 20
Teradata Vantage
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-03-26
dita:mapPath
ron1747160181474.ditamap
dita:ditavalPath
ft:empty
dita:id
vkz1472241255652
lifecycle
latest
Product Category
Teradata Vantageā„¢
The utility described is not available for as-a-service customers.

The Query Session utility, qrysessn, provides information about active Database Engine 20 sessions. It allows you to monitor the state of all or selected database sessions on all or selected logical host IDs attached to the Database Engine 20. 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.