Table and query to find status of Explain

Database
Enthusiast

Table and query to find status of Explain

On Viewpoint (when running a query), if you click the session>explain it points out the number of step and its status ("active")

How can you find this info when trying to run a query in SQL Assistant?

2 REPLIES 2
Ambassador

Re: Table and query to find status of Explain

Seems you're looking for the PMPC API SQL Interface, e.g. MonitorSQLCurrentStep

Enthusiast

Re: Table and query to find status of Explain

I guess MonitorSQLSteps section from your link checks out

from 

MonitorSQLSteps
  (HostIdIn              SMALLINT,
   SessionNoIn           INTEGER,
   RunVProcNo            SMALLINT)

How do you check your HostIDnumber and RunVProcNo on Viewpoint or SQL Assistant/Teradata Admin?