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

Database Utilities

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-05-02
dita:mapPath
ymn1628096214445.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
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 Analytics Database sessions. It allows you to monitor the state of all or selected database sessions on all or selected logical host IDs attached to the Analytics Database. 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.