Sample PM/API MONITOR SESSION Request Responses - Teradata Database - Teradata Vantage NewSQL Engine

Application Programming Reference

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-02
dita:mapPath
vwf1492987142269.ditamap
dita:ditavalPath
changebar_rev_16_20_exclude_audience_ie.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantage™

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.