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