Re: Current processed SQL statement
In article <35364333.2498@bloomberg.com>, Art S. Kagel
<kagel@bloomberg.com> writes
>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
Itsn't sqz_sqlstatement only char(200). I have larger statements.
onstat -g sql can get the full statement, what is going on?
>FROM syssqexplain
>WHERE sqx_sessionid = <session id of the other connection>
>
>Art S. Kagel
--
David Williams
Maintainer of the Informix FAQ
Primary site (Beta Version) http://www.smooth1.demon.co.uk
Official site http://www.iiug.org/techinfo/faq/faq_top.html
I see you standin', Standin' on your own, It's such a lonely place for you, For
you to be If you need a shoulder, Or if you need a friend, I'll be here
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care