15.10 - Sample PM/API MONITOR SESSION Request Responses - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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.

Note: 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

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