15.00 - FastLoad Sessions State 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

FastLoad Sessions State Displays

Several displays for sessions are part of FastLoad operations.

The following sections describe those displays:

  • 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.