How can I stop logging remote server requests?

[Former Member]

My procedure repeatedly selects data from remote server and these unnecessary information fill server window. For example:

The query is being processed in FULL PASSTHRU mode
The Original Statement is 
    select ... tornado.LgotList ....
The Virtual Statement is 
    select vt_1.expr_1,vt_1.expr_2,vt_1.expr_3,vt_1.expr_4 from vt_1

In my case SELECT PROPERTY( 'RequestLogging' ) reports NONE.

[Breck_Carter]

Short answer: Try this...

SET OPTION PUBLIC.cis_option = '0';

Long answer: It's not request level logging, it's remote data access logging, also known as CIS debugging where "CIS" stands for Component Integration Services which is the name for a previous incarnation of the middleware software which used to support remote data access, also known as "proxy tables".

This will tell you if it's on:

SELECT CONNECTION_PROPERTY ( 'cis_option' );

CONNECTION_PROPERTY('cis_option')
--------------------------------- 
7

If you have code in your application that does SET TEMPORARY OPTION cis_option = '7' then you will have to hunt that code down and remove it.

If you have set the option for the whole database with SET OPTION PUBLIC.cis_option = '7' then you can turn it off for the whole database with SET OPTION PUBLIC.cis_option = '0'.

Here is what the '7' value does for you...

SET OPTION PUBLIC.cis_option = '7';
SELECT * FROM proxy_t ORDER BY proxy_t.pkey;

The query is being processed in FULL PASSTHRU mode
The Original Statement is 
    select proxy_t.pkey,proxy_t.data from proxy_t order by proxy_t.pkey asc
The Virtual Statement is 
    select vt_1.expr_1,vt_1.expr_2 from vt_1
The Remote Statement for vt_1 is 
    select proxy_t.pkey,proxy_t.data from proxy_t order by proxy_t.pkey asc
Execute (ddd2_server): 
SELECT t1."pkey" , t1."data" FROM "t" t1  ORDER BY t1."pkey" ASC