Returns the name of the specified user ID who is causing a block.
Syntax
REPLACE FUNCTION SYSLIB.IdentifyUser (
UserId INTEGER
) RETURNS VARCHAR(128) CHARACTER SET UNICODE
...
;
Syntax Elements
- UserId
- ID of the user who is causing the block.
Usage Notes
The IdentifyUser function provides similar functionality to the PMPC IDENTIFY USER request. For information about this interface, see IDENTIFY.
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;
Result:
*** Query completed. One row found. 3 columns returned. *** Total elapsed time was 4 seconds. blocking user blocking table blocking db --------------------------- ----------------------- ------------- user1 skewAmp1 DBaaa