Sample PM/API MONITOR SESSION Request Responses | Teradata Vantage - 17.10 - Sample PM/API MONITOR SESSION Request Responses - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

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.