15.10 - MonitorSQLText - Teradata Database

Teradata Database Application Programming Reference

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

Returns the SQL text of the request currently being executed for the specified host, session, and vproc.

REPLACE FUNCTION SYSLIB.MonitorSQLText
  (HostIdIn     SMALLINT,
   SessionNoIn  INTEGER,
   RunVProcNo   SMALLINT
  )
  RETURNS TABLE
   (HostId      SMALLINT,
    SessionNo   INTEGER, 
    SeqNum      SMALLINT,
    SQLTxt      VARCHAR(31000) CHARACTER SET UNICODE
   )
            .
            .
            .
;
 

Parameter

Description

HostIdIn

Logical ID of a host (or client) with sessions logged on.

SessionNoIn

Session number of the SQL to monitor.

RunVprocNo

PE vproc number where the session runs.

This table function is only supported in Constant Mode.

If MONITOR SQL processing is not completed within the timeout interval, then an error is returned to the client application. When a MONITOR SQL request is timed out, the processing continues internally to its completion. If the client application submits a new MONITOR SQL request for the same timed out target session while the previous timed out one is still being processed, then an error is returned.

The timeout interval can be set in the DBS Control field, PMPC_TimeoutSecs. The default timeout interval is 60 seconds. If the PMPC_TimeoutSecs field is set to zero, the MONITOR SQL timeout request will be disabled and no timeout will occur. For more information on the PMPC_TimeoutSecs field, see Utilities.

The MonitorSQLText function provides similar functionality to the PMPC MONITOR SQL request. For information about this interface, see “MONITOR SQL” on page 149.

 

Column Name

Description

HostId

Host ID of the SQLtext.

SessionNo

Session number of the SQLtext.

SeqNum

Sequence number of the row. For example, if the SQL text exceeds 31,000 bytes, the system will return multiple rows.

SQLTxt

SQL text of the running request.

SELECT SQLTxt FROM TABLE (MonitorSQLText(1, 1001, 16383)) AS t2;
 
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 58 seconds.
 
SQLTxt
------------------------------------------------------------------------
select a11.c1, a12.c1, a13.c1, a21.c1, a22.c1, a23.c1  from dbaaa.skewAmp1
 a11, dbaaa.skewAmp1 a12, dbaaa.skewAmp1 a13, dbaaa.skewAmp1 a21, dbaaa.sk
ewAmp1 a22, dbaaa.skewAmp1 a23;