IdentifySession Function | Application Programming Reference | Teradata Vantage - 17.05 - IdentifySession - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

Purpose

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

Definition

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

Input Parameters

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

Usage Notes - IdentifySession

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

Return Value

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

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