Query Session Displays - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

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 Archive and Recovery, 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, FastExport, or an Archive and Recovery 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, FastExport, or an Archive and Recovery 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 could 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.