15.00 - Archive and Recovery 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

Archive and Recovery Sessions State Displays

Several displays for sessions are part of the Archive and Recovery operations. If you request detail information, Query Session reports child sessions and the parent information.

The following sections describe these displays:

  • Active Parent Session with Regular Request
  • Active Parent Session with Directed Request
  • Inactive Parent Session
  • Child Session
  • Active Parent Session with Regular Request Display

    The following shows an example display for a parent session involved in an Archive and Recovery operation.

    State Details : Active Parent Session with regular request involved in HUT.
    Operation: Restore

    Statements Dispatched Time     CPU Usage Accesses Byte Count
    ---------- ---------- -------- --------- -------- ----------
             1          1 14:22:09         2       22      2,367

    The Active State Display for a parent session involved in processing an Archive and Recovery request 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.

    Byte Count

    total number of bytes accessed by the Archive and Recovery operation.

    Active Parent Session with Directed Request Display

    The following shows an example display for a parent session involved in an Archive and Recovery operation processing a directed request.

    State Details : Active Parent Session with directed request involved in HUT.

    Request # Operation Time     CPU Usage Accesses Byte Count
    --------- --------- -------- --------- -------- ----------
            1 Restore   14:22:09         2       22      6,234

    The directed request active state display for a parent session involved in processing an Archive and Recovery request contains the following information.

     

    The column named...

    Contains the...

    Request #

    number of the request.

    Operation

    type of operation being performed.

    Time

    time that the last step for the highest statement 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.

    Byte Count

    total number of bytes accessed by the Archive and Recovery operation.

    Inactive Parent Session Display

    The following shows an example display for an inactive parent session involved in an Archive and Recovery operation.

    State Details : Inactive Parent Session involved in HUT.
     
    Operation CPU Usage Accesses Byte Count
    --------- --------- -------- ----------
    Restore       1,234    9,543  1,259,234

    The inactive state display for a parent session involved in processing an Archive and Recovery request contains the following information.

     

    The column named...

    Contains the...

    Operation

    type of operation being performed.

    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.

    Byte Count

    total number of bytes accessed by the Archive and Recovery operation.

    Child Session Display

    The following shows an example display for child sessions involved in an Archive and Recovery operation.

    Session # Request # State    TimeStamp Byte Count
    --------- --------- -------- --------- ----------
         1063      1759 Inactive 17:57:21       1,023
         1064      1755 Active   17:57:30          69
         1065      1754 Inactive 17:57:41       3,024

    Child sessions involved in Archive and Recovery 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 re-initiated to another AMP, or a response is sent to the host.

    Byte Count

    total number of bytes accessed by the session.