Were you able to come up with a script to find out what you are looking for with out using some thing like TASM?
If so, Can you please share it?
If you have select access on DBC.SessionTbl ..try this.
select * from DBC.SessionTbl where currentdatabase='DB_Name' AND USERNAME='User_Name' ORDER BY SESSIONNO;
Neither DBC.SessionInfo nor DBC.SessionTbl give you active sessions. They list all "connected" sessions, whether these are active or idle or delayed.
Hello, This is what I do to find active sessions:
FROM TABLE(MonitorSession(-1, '*', 0)) AS T2;