|
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. |
|
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
|
