Query Session Displays - 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 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.