Hi all. I'd like some assistance with the use of sql trace and dynamic explain.
When I encounter a long-running session, I try to use "onmode -Y [sessionid] 1 /tmp/filename.sessionid" to get some more detail. Sometimes that works for me, sometimes I get nothing. When I get no output, I can confirm that the session is ticking over statements, it's not idle. Just no output.
If that fails, I move onto sql trace:
execute function task ("set sql tracing on session [sessid]","10000","2","med","user")
This turns it on for all sessions, not just the one I'm focusing on.
I do get the detail from sql trace, but sometimes it's like trying to sip from the fire hydrant, and other times I would prefer the explain output of onmode -Y. EXPLAIN_STATS is always on.
Regards
Jason
------------------------------
Jason Ball
------------------------------
#Informix