15.00 - Chapter 20 Query Session (qrysessn) - Teradata Database

Teradata Database Utilities

Teradata Database
Release Number
Content Type
Publication ID
English (United States)
Last Update

The Query Session utility, qrysessn, provides information about active Teradata 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 Teradata Database. Query Session is also known as Session States.

This chapter provides an overview of the information Query Session reports as well as several sample Query Session displays.

Because 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 this chapter.

Scenarios Runs From

  • Database Window or comparable interface to the Teradata Database console subsystem, such as cnsterm
  • Teradata Viewpoint Remote Console portlet
  • Host Utility Console
  • For general information on starting the utilities from different interfaces, see Appendix B: “Starting the Utilities” For information on Viewpoint, see Teradata Viewpoint User Guide.