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