IdentifyUser Function | Application Programming Reference | Teradata Vantage - 17.05 - IdentifyUser - 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

Returns the name of the specified user ID who is causing a block.

Definition

REPLACE FUNCTION SYSLIB.IdentifyUser
  (UserId  INTEGER
  )
 RETURNS VARCHAR(128) CHARACTER SET UNICODE
          .
          .
          .
;

Input Parameter

Parameter Description
UserId ID of the user who is causing the block.

Usage Notes - IdentifyUser

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

Return Value

This function returns the name of the user.

Example: Using IdentifyUser

SELECT IdentifyUser(blk1userid) as "blocking user",
    IdentifyTable(blk1objtid) as "blocking table",
    IdentifyDatabase(blk1objdbid) as "blocking db"
FROM TABLE (MonitorSession(-1,'*',0)) AS t1
WHERE Blk1UserId > 0;
 *** Query completed. One row found. 3 columns returned.
 *** Total elapsed time was 4 seconds.
blocking user               blocking table          blocking db
--------------------------- ----------------------- -------------
user1                       skewAmp1                DBaaa