IdentifySession Function | Application Programming Reference | Teradata Vantage - 17.10 - IdentifySession - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Returns the name of the user, by session, who is causing a block.

Syntax

REPLACE FUNCTION SYSLIB.IdentifySession (
  HostId INTEGER,
  SessionNo INTEGER
) RETURNS VARCHAR(128) CHARACTER SET UNICODE
  ... 
;

Syntax Elements

HostId
ID of the blocking host.
SessionNo
Number of the session that is blocked.

Usage Notes

The IdentifySession function provides similar functionality to the PMPC IDENTIFY SESSION request. For information about this interface, see IDENTIFY.

Example: Using IdentifySession

SELECT IdentifySession(blk1Hostid,blk1sessno)
FROM TABLE (MonitorSession(-1,'*',0)) AS t1
WHERE Blk1UserId > 0;
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
IdentifySession(Blk1HostId,Blk1SessNo)
--------------------------------------
USER1