16.10 - Archive and Recovery Sessions State Displays - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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.