As described in the table below, the MONITOR SESSION request returns both the PEState and AMPState response values. A client performance monitoring application interprets the meaning of the PEState and AMPState combination, which is displayed as the session state in the client application.
You can view different session states in Teradata Viewpoint and filter for the types of sessions you wish to view.
The session state is not returned by any PM/API CLIv2 or Teradata JDBC Driver request. It is interpreted by the client application.
If PEState is… | AND AMPState is… | THE resulting session state displays… |
---|---|---|
HOST-RESTART | any AMP state | HOST-RESTART |
ABORTING | ABORTING | ABORTING |
ABORTING | ACTIVE | ABORTING |
ABORTING | BLOCKED | ABORTING |
ABORTING | IDLE | ABORTING |
ABORTING | UNKNOWN | ABORTING |
PARSING-WAIT | ABORTING | ABORTING |
PARSING-WAIT | BLOCKED | BLOCKED |
PARSING-WAIT | ACTIVE | PARSING |
PARSING-WAIT | IDLE | PARSING |
PARSING-WAIT | UNKNOWN | PARSING |
PARSING | ABORTING | ABORTING |
PARSING | BLOCKED | BLOCKED |
PARSING | ACTIVE | PARSING |
PARSING | IDLE | PARSING |
PARSING | UNKNOWN | PARSING |
DISPATCHING | ABORTING | ABORTING |
DISPATCHING | BLOCKED | BLOCKED |
DISPATCHING | ACTIVE | ACTIVE |
DISPATCHING | IDLE | IDLE |
DISPATCHING | UNKNOWN | ACTIVE |
ELICIT CLIENT DATA | ABORTING | ABORTING |
ELICIT CLIENT DATA | BLOCKED | BLOCKED |
ELICIT CLIENT DATA | ACTIVE | ACTIVE |
ELICIT CLIENT DATA | IDLE | ACTIVE |
ELICIT CLIENT DATA | UNKNOWN | ACTIVE |
RESPONSE | ABORTING | ABORTING |
RESPONSE | BLOCKED | BLOCKED |
RESPONSE | ACTIVE | RESPONSE |
RESPONSE | IDLE | RESPONSE |
RESPONSE | UNKNOWN | RESPONSE |
RESPONSE-HELD | any AMP state | RESPONSE-HELD |
ACTIVE | ABORTING | ABORTING |
ACTIVE | BLOCKED | BLOCKED |
ACTIVE | ACTIVE | ACTIVE |
ACTIVE | IDLE | ACTIVE |
ACTIVE | UNKNOWN | ACTIVE |
IDLE: IN-DOUBT | ABORTING | UNKNOWN |
IDLE: IN-DOUBT | BLOCKED | UNKNOWN |
IDLE: IN-DOUBT | ACTIVE | UNKNOWN |
IDLE: IN-DOUBT | IDLE | UNKNOWN |
IDLE: IN-DOUBT | UNKNOWN | UNKNOWN |
IDLE | ABORTING | IDLE |
IDLE | BLOCKED | IDLE |
IDLE | ACTIVE | IDLE |
IDLE | IDLE | IDLE |
IDLE | UNKNOWN | IDLE |
DELAYED | any AMP state | DELAYED |
SESDELAYED | any AMP state | SESDELAYED |
QTDELAYED | any AMP state | QTDELAYED |
BLOCKED | IDLE | BLOCKED A BLOCKED session state in monitor partition session means some background activity is in progress and the last request is on hold until this background activity is completed. Database locks are not directly involved in BLOCKED monitor partition sessions.
|