17.10 - Query Session Displays - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

The following sections describe the Query Session displays that provide information on what you can input. General Help displays are described first, followed by displays for sessions involved in FastLoad, FastExport, and MultiLoad operations.

After you have started Query Session, it prompts for the following:

Please Enter A Logical Host ID (? For Help)

You can type any of the following responses when you are prompted for the logical host ID.

IF you type... THEN...
an integer Query Session provides information only for the sessions associated with the specified logical host ID.
an asterisk (*) Query Session provides information on sessions for every logical host.
a question mark (?) you will get Help for this entry.
a carriage return (Enter) you will exit from the Query Session utility.

If you type an integer or an asterisk, the following prompt displays:

Please Enter Session Ids (? For Help):

You can input any of the following when you are prompted for the Session ID.

IF you type... THEN you see...
an integer to indicate a specific session ID
You can input up to five session Ids in integer format. You can type them on one line separated by spaces or on multiple lines.
the following prompt:
Is detail information needed if the session is involved in HUT/FastLoad/MLoad/Export?
y-yes, n-no
  • To view the Child session, type y.
  • If the session is not part of a FastLoad, MultiLoad, or FastExport operation, type n.
an asterisk (*) the following prompt:
Is detail information needed if the session is involved in HUT/FastLoad/MLoad/Export?
y-yes, n-no
  • To view the Child session states, type y.
  • If the session is not part of a FastLoad, MultiLoad, or FastExport operation, type n.
a question mark help concerning input information.
If an unsuccessful attempt was made to obtain temporary table information for the given session, the following query session message can appear:

WARNING: Session may contain incomplete temporary table information due to deadlock!

If temporary table information is important to you, then you should retry querying the session at a later time.