MonitorSQLCurrentStep Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
HostIdIn
Logical ID of a host (or client) with sessions logged on.
A value of -1 indicates all hosts.
SessionNoIn
Session number of the SQL to monitor.
RunVprocNo
PE vproc number where the session runs.
HostId
Logical host ID associated with a PE or session. For a PE, HostId identifies one of the hosts or LANs associated with the described PE. For a session, the combination of a host ID and a session number uniquely identifies a user session on the system.
This value is NULL for AMPs. A value of zero represents the Supervisor window.
SessionNo
Number of the current session. With a given host ID, a session number uniquely identifies a session on the database system. This value is assigned by the host (or client) at logon time.
DynamicPlan
Plan type:
  • 0 = Static plan
  • 1 = Dynamic plan
See EXPLAIN Request Modifier.
PartialSteps
Possible values:
  • 0 = All steps are returned
  • 1 = Partial plan or no plan is returned

    If a partial plan is returned, this indicates the steps for the final plan fragment of the dynamic explanation of the request has not yet been generated.

    If no plan is returned, this indicates the request has been throttled and is in the delay queue.

A value 1 cannot occur for a static plan.
For more information on static and dynamic explanations of a request, see STATIC EXPLAIN and DYNAMIC EXPLAIN.
NumOfSteps
Number of steps in the description text in the third statement of the response.
Plan DynamicPlan Field Value PartialSteps Field Value NumOfSteps
Static 0   Number of steps for plan.
Complete dynamic 1 0 Number of steps for plan.
Partial dynamic 1 1 Number of steps generated.
If a request with a partial dynamic plan has been throttled and is in the delay queue (that is, no rows are returned in response to the third statement), NumOfSteps is zero.
For more information, see the MONITOR SQL DynamicPlan and PartialSteps fields.
CurLvl1StepNo
Number of the running level 1 step. If parallel steps are running, this is the number of the lowest running step.
If this is a request with a dynamic plan that has been throttled and is in the delay queue (for example, when the NumOfSteps field value is zero and both the DynamicPlan are PartialSteps field values are 1), the CurLvl1StepNo field value is zero.
CurLvl2StepNo
Number of the running step. If parallel steps are running, this is the number of the highest executing step. If only one step is running, CurLvl1StepNo and CurLvl2StepNo are identical.
If this is a request with a dynamic plan that has been throttled and is in the delay queue (for example, when the NumOfSteps field value is zero and both the DynamicPlan are PartialSteps field values are 1), the CurLvl2StepNo field value is 1.
If only one step is executing, CurLvl1StepNo and CurLvl2StepNo are identical.
ZoneId
The unique identifier of the zone.
SPName
The outer stored procedure name, if a stored procedure is running.
NULL is returned in indicator mode if no stored procedure is running.
SPDName
This is the owner database name of the outer stored procedure if a stored procedure is running.
NULL is returned in indicator mode if no stored procedure is running.
DefaultDBName
This field returns the default database name of the session at the start of the non-stored procedure request. For stored procedures, this field returns the default database name of the session when the stored procedure was compiled.