15.10 - IdentifySession - Teradata Database

Teradata Database Application Programming Reference

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

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

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

Parameter

Description

HostId

ID of the blocking host.

SessionNo

Number of the session that is blocked.

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

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

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