Hello,

I´d like to know how can I get the statement that is running for a
specific connection.

The following SQL command returns NULL in the Value column:

select value
from sa_conn_properties()
where number = 59
and propname = 'laststatement';

I have an undesired connection on my database that uses a lot of
temporary disk space. I´ve created an event that is triggered on a
specifc TempFreePercent value. This event sends me an e-mail and I
need to know wich is the problematic query.

Thank you.
Thiago Reis<thiago.reis (AT) embraer (DOT) com.br>

Thiago,

Are you running the server with the "-zl" switch?

http://www.ianywhere.com/developer/p...9/00000215.htm

Regards,

Thiago wrote:
--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

You need to be running your server with the -zl
or enable it from a startup event with a call to
sa_server_option( 'RememberLastStatement','ON');
first before that property will show any values.



"Thiago" <gorpo81 (AT) gmail (DOT) com> wrote

Hello,

I´d like to know how can I get the statement that is running for a
specific connection.

The following SQL command returns NULL in the Value column:

select value
from sa_conn_properties()
where number = 59
and propname = 'laststatement';

I have an undesired connection on my database that uses a lot of
temporary disk space. I´ve created an event that is triggered on a
specifc TempFreePercent value. This event sends me an e-mail and I
need to know wich is the problematic query.

Thank you.
Thiago Reis<thiago.reis (AT) embraer (DOT) com.br>

Jeff and Nick,

Thank you very much for your help.

I was not running my server with the "-zl" switch.


Now it´s working.

Best regards,
Thiago.