REPLACE FUNCTION SYSLIB.MonitorSQLText (
HostIdIn SMALLINT,
SessionNoIn INTEGER,
RunVprocNo SMALLINT
) RETURNS TABLE (
HostId SMALLINT,
SessionNo INTEGER,
SeqNum SMALLINT,
SQLTxt VARCHAR(31000) CHARACTER SET UNICODE
)
...
;
Syntax Elements
- 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.
- 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 returns multiple rows.
- SQLTxt
- SQL text of the running request.