17.10 - FastLoad Sessions State 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 displays that are part of FastLoad operations:

  • Active Parent Session in a Loading Phase
  • Active Parent Session in a Nonloading Phase
  • Inactive Parent Session in a Loading Phase
  • Inactive Parent Session in a Nonloading Phase
  • Child Sessions

If you request detail information, Query Session reports child sessions as well. These displays are identified after the phrase State Details by two lines describing the current phase.

Information for a FastLoad session in the loading phase is different from information for a non-loading phase of FastLoad.

Active Parent Session in a Loading Phase Display

The following example shows a display of an active parent session for a FastLoad operation in the loading phase.

State Details : Active Parent Session involved in FASTLOAD utility
FastLoad Phase : Loading

Statements Dispatched Time     CPU Usage Accesses Row Count
---------- ---------- -------- --------- -------- ---------
         1          1 14:22:09    15,110    6,462     2,060

The display for an active parent session in the loading phase of a FastLoad operation contains the following information.

The column named... Contains the...
Statements total number of statements in the current session request.
Dispatched highest statement number dispatched to the AMPs.
Time time that the last step for the highest statement number was sent to the AMPs.
CPU Usage accumulated time in thousandths of a second that all AMPs spent processing the current request.
Accesses total number of segment access calls executed on all AMPs for the session request.
Row Count total number of rows loaded by the FastLoad utility.

Active Parent Session in a Nonloading Phase Display

The following shows an example display of an active parent session of a FastLoad operation in any phase other than the loading phase.

State Details : Active Parent Session involved in FASTLOAD utility
FastLoad Phase : LoadPending
               
Statements Dispatched Time     CPU Usage Accesses
---------- ---------- -------- --------- --------
         1          1 14:22:09         2       22

The display for an active parent session in any phase other than the loading phase of a FastLoad operation contains the following information.

The column named... Contains the...
Statements total number of statements in the current session request.
Dispatched highest statement number dispatched to the AMPs.
Time time that the last step for the highest statement number was sent to the AMPs.
CPU Usage accumulated time in thousandths of a second that all AMPs spent processing the current request.
Accesses total number of segment access calls executed on all AMPs for the session request.

Inactive Parent Session in a Loading Phase Display

The following shows an example display of an inactive parent session of a FastLoad operation in the loading phase.

State Details : Inactive Parent Session involved in FASTLOAD utility
FastLoad Phase : Loading
               
CPU Usage Accesses Row Count
--------- -------- ---------
      234      567   456,321

The display for an inactive parent session in the loading phase of a FastLoad operation contains the following information.

The column named... Contains the...
CPU Usage accumulated time in thousandths of a second that all AMPs spent processing the current request.
Accesses total number of segment access calls executed on all AMPs for the session request.
Row Count total number of rows loaded by the FastLoad utility.

Inactive Parent Session in a Nonloading Phase Display

The following shows an example display of an inactive parent session involved in a FastLoad operation in any phase other than the loading phase.

State Details : Inactive Parent Session involved in FASTLOAD utility.
FastLoad Phase : Load Pending
               
CPU Usage Accesses
--------- --------
       65      870

The inactive parent session display for sessions involved in any phase other than the loading phase contains the following information.

The column named... Contains the...
CPU Usage accumulated time in thousandths of a second that all AMPs spent processing the current request.
Accesses total number of segment access calls executed on all AMPs for the session request.

Child Sessions Display

A FastLoad operation only involves child sessions when in the loading phase.

If the parent of the queried child session is not in the loading phase, the child session information is not available. The following shows an example display for child sessions involved in a FastLoad operation when the long form of the display is requested in response to the Detail Information Needed prompt.

Session # Request # State    TimeStamp Byte Count
--------- --------- -------- --------- ----------
     1055      1632 Inactive 15:57:10       5,286
     1056      1635 Active   15:57:23         372

The display for Child sessions involved in FastLoad operations contain the following information.

The column named... Contains the...
Sessions# session identifier.
Request # number of the request.
State state of the session, indicating whether the session is active or inactive.
TimeStamp time that is updated whenever a request is received from the host, a request is reinitiated to another AMP, or a response is sent to a host.
Row Count total number of rows loaded by the session.