15.00 - Query Session Displays - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Query Session Displays

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

Note: 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.

    Note: 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.