Re: Current processed SQL statement

Posted in 1998

Art S. Kagel — Thu, 16 Apr 1998 13:43:15 -0400 — source: Informix-list mailing list archive (1991-1998)

Johannes Plassmann wrote: > > Hi there, > I've a question of how to determine a currently processed SQL STATEMENT. > > Imagine a thread which is processing a bunch of sql statements and > another thread which wants to figure out which statement is currently > processed. Open a second connection to the sysmaster database from this monitor thread and execute the following: SELECT sqx_sessionid, sqx_selflag[4,12] sttmt_type, sqx_sqlstatement statement FROM syssqexplain WHERE sqx_sessionid = <session id of the other connection> Art S. Kagel