15.00 - MultiLoad 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

MultiLoad Sessions State Displays

Several displays are defined for the sessions that are part of MultiLoad operations.

The following sections describe those displays:

  • Preliminary Phase Sessions
  • Application Phase Session for Apply Task
  • Application Phase Session for Delete Task
  • Active Parent Session in an Acquisition Phase
  • Inactive Parent Session in an Acquisition Phase
  • Child Session in an Acquisition Phase
  • In addition to the phase State Detail line, a line describing the current phase is displayed.

    If the session is in the Preliminary or Application phase, the current task type (Delete or Apply) is displayed. The information displayed is different for each phase: Preliminary, Application, and Acquisition. In the Application phase, each of the two task types is displayed.

    When the action involves more than one AMP, row count summaries are meaningless and are not reported.

    Preliminary Phase Session Display

    The following shows an example display session, that is part of a MultiLoad operation, in the Preliminary phase.

    State Details : Session involved in MLOAD utility
    MLoad Phase : Preliminary - Received all DML Steps.
    Task Running : Apply Task
                   
    Statements Dispatched Time     CPU Usage Accesses DMLCount
    ---------- ---------- -------- --------- -------- --------
            10          2 12:09:09         7       15        5

    The possible tasks include Apply Task and Delete Task. These are the Subphases:

  • No MLOAD step has been received.
  • Receiving MLOAD step.
  • Received all MLOAD steps.
  • Received all DML (Data Manipulation Language) steps.
  • The state display for the preliminary phase of a MultiLoad 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.

    DML Count

    number of DML steps received if the current phase is Received all DML Steps.

    Application Phase Session for Apply Task Display

    The Query Session display for each table during an Apply Task includes the name of the database and table, the current action, the number of workrows applied, and the total number of workrows. The following shows an example display session involved in a MultiLoad operation during an Apply Task.

    State Details : Session involved in MLOAD utility
    MLoad Phase : Application.
    Task Running : Apply Task
                   
    Statements Dispatched Time     CPU Usage Accesses
    ---------- ---------- -------- --------- --------
             1          1 11:09:37    811751  349,637
                   
    DataBase.Table                = SPOOL_RES.WT_TDEM_PAIMT_MED
    Action                        = Process Data and Secondary index
    # of WorkRows applied         =  1,210,838
    Total # of WorkRows           = 51,639,908
    # of NUSI change rows applied =          0
    Total # of NUSI change rows   =          0     

    The display for active parent sessions involved in the Apply Task of a MultiLoad operation provides 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.

    In addition, the display provides the following information.

     

    Field

    Description

    DataBase.Table

    Identifies the table on which the MultiLoad operation is running.

    Action

    Describes the action being performed in the MultiLoad session.

    # of WorkRows applied

    Displays the number of work rows processed in the apply phase.

    Total # of WorkRows

    Displays the total number of rows processed.

    # of NUSI change rows applied

    Number of nonunique secondary index rows processed in the apply phase.

    Total # of NUSI change rows

    Total number of nonunique secondary index rows processed.

    Application Phase Session for Delete Task Display

    The following shows an example of the Query Session display for each table during a Delete Task, which includes the name of the database and table, the current action, the number of rows scanned, and the number of rows deleted.

    State Details : Session involved in MLOAD utility
    MLoad Phase : Application.
    Task Running : Delete Task

    Statements Dispatched Time     CPU Usage Accesses
    ---------- ---------- -------- --------- --------
             3          3 11:24:32    844679  310,987
                   
    DataBase.Table                = SPOOL_RES.WT_TDEM_PAIMT_MED
    Action                        = Process Data
    # of rows scanned             =  22,357
    # of rows deleted             = 245,349

    Note: The values shown include both the primary and the fallback count.

    The Delete Task display for a MultiLoad operation contains the same information as described for the Apply Task display except that it reports the number of rows processed and deleted rather than the rows processed by the apply phase.

    Active Parent Session in an Acquisition Phase Display

    The following shows an example display of an active parent session which is part of a MultiLoad operation.

    State Details : Active Parent Session involved in MLOAD utility
    MLoad Phase : Acquisition - Data Loading is in progress.
                   
    Statements Dispatched Time     CPU Usage Accesses Row Count
    ---------- ---------- -------- --------- -------- ---------
             1          1 09:23:45         8      166     9,854 

    If you request detail information, Query Session reports child sessions as well. These are the descriptions of the phase:

  • Data Loading is in progress.
  • Data Loading is complete.
  • The display for active parent sessions involved in MultiLoad operations provides 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 processed by the MultiLoad task.

    Inactive Parent Session in an Acquisition Phase Display

    The following shows an example display of an inactive parent session that is part of a MultiLoad operation.

    State Details: InActive Parent Session involved in MLOAD Utility
    MLoad Phase : Acquisition - Data Loading is complete.
                   
    CPU Usage Accesses Row Count
    --------- -------- ---------
          130      654    45,673

    These are the possible descriptions of the phase:

  • Data Loading is in progress.
  • Data Loading is complete.
  • The display for inactive parent sessions involved in a MultiLoad 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 processed by the MultiLoad task.

    Child Session in an Acquisition Phase Display

    The following shows an example display for child sessions involved in a MultiLoad operation when the long form of the display is requested in response to the Detail Information Needed prompt.

    State Details: CHILD session involved in MLOAD Acquisition Phase
                   
    Session # Request # State    TimeStamp Row Count
    --------- --------- -------- --------- ---------
         1055      1632 Inactive 15:57:10      5,286
         1056      1635 Active   15:57:23        372

    Child sessions involved in MultiLoad operations display these columns.

     

    The column named...

    Contains the...

    Session #

    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 the host.

    Row Count

    total number of rows loaded by the session.