SEL USERNAME ,
SESSIONNO ,
HOSTID ,
IDENTIFYUSER(BLK1USERID) as BockedBy ,
BLK1SESSNO as BlockedBySessionNO
FROM TABLE
(SYSLIB.MONITORSESSION(-1,'*',0)) AS T1
WHERE (AMPSTATE='BLOCKED' OR PESTATE='BLOCKED')
AND
USERNAME <> IDENTIFYUSER(BLK1USERID)
ORDER BY 1,2;